PREVIEW / stock_30min / 2010-03-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-12.parquet
  size:    1.4 MB
  rows:    73,515
  symbols: 3,458

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-03-12 04:00:00	AAPL	Stock	8.0779	8.0779	8.0779	8.0779	2800.0
2010-03-12 04:30:00	AAPL	Stock	8.0964	8.1	8.0964	8.1	19600.0
2010-03-12 05:00:00	AAPL	Stock	8.1061	8.1061	8.1036	8.1043	22988.0
2010-03-12 05:30:00	AAPL	Stock	8.0971	8.0971	8.0968	8.0968	19600.0
2010-03-12 06:00:00	AAPL	Stock	8.1068	8.1068	8.1068	8.1068	5600.0
2010-03-12 06:30:00	AAPL	Stock	8.1036	8.1036	8.1036	8.1036	5796.0
2010-03-12 07:00:00	AAPL	Stock	8.1025	8.1036	8.0843	8.0943	293636.0
2010-03-12 07:30:00	AAPL	Stock	8.0929	8.0929	8.0854	8.0907	126588.0
2010-03-12 08:00:00	AAPL	Stock	8.0857	8.1086	8.0391	8.1004	2805740.0
2010-03-12 08:30:00	AAPL	Stock	8.1004	8.1268	8.1004	8.1225	2631384.0
2010-03-12 09:00:00	AAPL	Stock	8.1232	8.1246	8.115	8.12	1389920.0
2010-03-12 09:30:00	AAPL	Stock	8.1196	8.1332	8.0718	8.1286	101517920.0
2010-03-12 10:00:00	AAPL	Stock	8.1293	8.1318	8.0675	8.0939	63284004.0
2010-03-12 10:30:00	AAPL	Stock	8.0943	8.11	8.0754	8.095	29656424.0
2010-03-12 11:00:00	AAPL	Stock	8.095	8.1161	8.0896	8.1075	23434656.0
2010-03-12 11:30:00	AAPL	Stock	8.1078	8.1096	8.09	8.0957	14326564.0
2010-03-12 12:00:00	AAPL	Stock	8.0954	8.1071	8.0918	8.105	14081228.0
2010-03-12 12:30:00	AAPL	Stock	8.105	8.1058	8.0932	8.1014	12411784.0
2010-03-12 13:00:00	AAPL	Stock	8.1018	8.1021	8.0893	8.0914	10569384.0
2010-03-12 13:30:00	AAPL	Stock	8.0918	8.0993	8.0814	8.0958	15855980.0
2010-03-12 14:00:00	AAPL	Stock	8.0959	8.1075	8.095	8.1007	20135500.0
2010-03-12 14:30:00	AAPL	Stock	8.1007	8.1089	8.0929	8.103	16754528.0
2010-03-12 15:00:00	AAPL	Stock	8.1025	8.1046	8.0625	8.0661	33413912.0
2010-03-12 15:30:00	AAPL	Stock	8.0657	8.1021	8.0643	8.0936	44359812.0
2010-03-12 16:00:00	AAPL	Stock	8.0921	8.0982	8.0583	8.0943	5046188.0
2010-03-12 16:30:00	AAPL	Stock	8.065	8.0939	8.065	8.0918	1319696.0
2010-03-12 17:00:00	AAPL	Stock	8.0932	8.0957	8.0875	8.0936	215404.0
2010-03-12 17:30:00	AAPL	Stock	8.0929	8.1007	8.0904	8.1007	246624.0
2010-03-12 18:00:00	AAPL	Stock	8.0916	8.1032	8.0916	8.1018	241108.0
2010-03-12 18:30:00	AAPL	Stock	8.1018	8.1018	8.0879	8.0925	103880.0
2010-03-12 19:00:00	AAPL	Stock	8.0929	8.0929	8.0882	8.0893	50904.0
2010-03-12 19:30:00	AAPL	Stock	8.0929	8.0929	8.0857	8.0857	175728.0
2010-03-12 20:00:00	AAPL	Stock	8.1004	8.1004	8.1004	8.1004	133840.0
2010-03-12 04:00:00	MSFT	Stock	29.2	29.28	29.2	29.28	980.0
2010-03-12 05:30:00	MSFT	Stock	29.38	29.38	29.38	29.38	500.0
2010-03-12 06:00:00	MSFT	Stock	29.38	29.38	29.38	29.38	115.0
2010-03-12 07:00:00	MSFT	Stock	29.26	29.3	29.26	29.3	2400.0
2010-03-12 07:30:00	MSFT	Stock	29.3	29.34	29.3	29.34	4000.0
2010-03-12 08:00:00	MSFT	Stock	29.34	29.36	29.28	29.29	28169.0
2010-03-12 08:30:00	MSFT	Stock	29.34	29.39	29.32	29.33	5201.0
2010-03-12 09:00:00	MSFT	Stock	29.33	29.39	29.28	29.32	23706.0
2010-03-12 09:30:00	MSFT	Stock	29.31	29.39	29.14	29.26	4668307.0
2010-03-12 10:00:00	MSFT	Stock	29.26	29.29	29.04	29.09	4744709.0
2010-03-12 10:30:00	MSFT	Stock	29.08	29.15	29.06	29.09	2535420.0
2010-03-12 11:00:00	MSFT	Stock	29.09	29.3	29.06	29.28	2660895.0
2010-03-12 11:30:00	MSFT	Stock	29.273	29.32	29.21	29.213	1987156.0
2010-03-12 12:00:00	MSFT	Stock	29.21	29.245	29.19	29.215	1048095.0
2010-03-12 12:30:00	MSFT	Stock	29.211	29.25	29.15	29.23	1574984.0
2010-03-12 13:00:00	MSFT	Stock	29.24	29.26	29.21	29.21	966828.0
2010-03-12 13:30:00	MSFT	Stock	29.21	29.25	29.19	29.23	1017325.0

> showing 50 of 73,515 rows — these rows as CSV

> unlock the full archive -- $79 one-time