PREVIEW / stock_30min / 2008-03-06

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-06.parquet
  size:    1.2 MB
  rows:    69,159
  symbols: 3,254

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
2008-03-06 04:30:00	AAPL	Stock	4.4711	4.4711	4.4711	4.4711	11200.0
2008-03-06 05:00:00	AAPL	Stock	4.4786	4.4786	4.4571	4.4571	16800.0
2008-03-06 06:30:00	AAPL	Stock	4.4575	4.4575	4.4571	4.4571	14000.0
2008-03-06 07:00:00	AAPL	Stock	4.4607	4.4821	4.4607	4.4714	203420.0
2008-03-06 07:30:00	AAPL	Stock	4.4714	4.4714	4.4464	4.4464	542220.0
2008-03-06 08:00:00	AAPL	Stock	4.4518	4.4571	4.4182	4.4275	1486212.0
2008-03-06 08:30:00	AAPL	Stock	4.4275	4.4371	4.4175	4.4339	1553888.0
2008-03-06 09:00:00	AAPL	Stock	4.4318	4.4636	4.4254	4.4504	3865764.0
2008-03-06 09:30:00	AAPL	Stock	4.4511	4.5457	4.4493	4.5321	205528792.0
2008-03-06 10:00:00	AAPL	Stock	4.5293	4.5496	4.4957	4.5314	152316332.0
2008-03-06 10:30:00	AAPL	Stock	4.5311	4.5536	4.5296	4.5489	98586348.0
2008-03-06 11:00:00	AAPL	Stock	4.5489	4.5536	4.5039	4.5114	80786160.0
2008-03-06 11:30:00	AAPL	Stock	4.5121	4.5357	4.505	4.5167	63767592.0
2008-03-06 12:00:00	AAPL	Stock	4.5175	4.5179	4.4657	4.4657	75753076.0
2008-03-06 12:30:00	AAPL	Stock	4.4657	4.4764	4.4357	4.4454	74064648.0
2008-03-06 13:00:00	AAPL	Stock	4.445	4.4889	4.4107	4.4214	135158268.0
2008-03-06 13:30:00	AAPL	Stock	4.4207	4.4393	4.3889	4.4086	116874044.0
2008-03-06 14:00:00	AAPL	Stock	4.4089	4.4671	4.4054	4.4382	96367544.0
2008-03-06 14:30:00	AAPL	Stock	4.4386	4.4564	4.405	4.4314	80215548.0
2008-03-06 15:00:00	AAPL	Stock	4.4304	4.4325	4.3793	4.4279	108088316.0
2008-03-06 15:30:00	AAPL	Stock	4.4268	4.4289	4.3146	4.3375	156681784.0
2008-03-06 16:00:00	AAPL	Stock	4.3368	4.4654	4.3171	4.3546	18852792.0
2008-03-06 16:30:00	AAPL	Stock	4.3518	4.5171	4.3189	4.3571	1388352.0
2008-03-06 17:00:00	AAPL	Stock	4.3571	4.3618	4.3189	4.35	835968.0
2008-03-06 17:30:00	AAPL	Stock	4.35	4.3571	4.3257	4.3564	464688.0
2008-03-06 18:00:00	AAPL	Stock	4.3482	4.3571	4.3475	4.3554	263844.0
2008-03-06 18:30:00	AAPL	Stock	4.3554	4.3607	4.3539	4.3539	135632.0
2008-03-06 19:00:00	AAPL	Stock	4.3543	4.3589	4.3464	4.3536	97440.0
2008-03-06 19:30:00	AAPL	Stock	4.3571	4.3571	4.3482	4.3564	115640.0
2008-03-06 07:30:00	MSFT	Stock	28.16	28.17	28.16	28.17	2100.0
2008-03-06 08:00:00	MSFT	Stock	28.17	28.17	28.02	28.1	107770.0
2008-03-06 08:30:00	MSFT	Stock	28.1	28.1	28.01	28.01	4070.0
2008-03-06 09:00:00	MSFT	Stock	28.01	28.11	27.99	28.1	211973.0
2008-03-06 09:30:00	MSFT	Stock	28.09	28.17	27.99	28.0	13019709.0
2008-03-06 10:00:00	MSFT	Stock	28.0	28.005	27.81	27.94	7127017.0
2008-03-06 10:30:00	MSFT	Stock	27.94	27.98	27.76	27.815	6911812.0
2008-03-06 11:00:00	MSFT	Stock	27.82	27.85	27.71	27.79	5047304.0
2008-03-06 11:30:00	MSFT	Stock	27.791	27.94	27.78	27.94	7110238.0
2008-03-06 12:00:00	MSFT	Stock	27.94	27.97	27.88	27.91	4741393.0
2008-03-06 12:30:00	MSFT	Stock	27.92	27.952	27.85	27.92	4484921.0
2008-03-06 13:00:00	MSFT	Stock	27.911	27.95	27.84	27.852	6148090.0
2008-03-06 13:30:00	MSFT	Stock	27.86	27.92	27.83	27.89	3546825.0
2008-03-06 14:00:00	MSFT	Stock	27.88	27.89	27.8	27.86	5410906.0
2008-03-06 14:30:00	MSFT	Stock	27.86	27.92	27.82	27.84	5097952.0
2008-03-06 15:00:00	MSFT	Stock	27.84	27.91	27.78	27.89	7169749.0
2008-03-06 15:30:00	MSFT	Stock	27.88	27.88	27.5	27.58	11964984.0
2008-03-06 16:00:00	MSFT	Stock	27.51	28.0	27.51	27.57	2755343.0
2008-03-06 16:30:00	MSFT	Stock	27.866	27.866	27.57	27.7	197159.0
2008-03-06 17:00:00	MSFT	Stock	27.57	27.67	27.57	27.67	32646.0
2008-03-06 17:30:00	MSFT	Stock	27.835	27.878	27.6	27.6	42900.0

> showing 50 of 69,159 rows — these rows as CSV

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