PREVIEW / stock_30min / 2008-05-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-07.parquet
  size:    1.3 MB
  rows:    68,713
  symbols: 3,288

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-05-07 06:00:00	AAPL	Stock	6.6539	6.6539	6.6539	6.6539	2800.0
2008-05-07 07:00:00	AAPL	Stock	6.66	6.6629	6.6321	6.6357	65800.0
2008-05-07 07:30:00	AAPL	Stock	6.6357	6.6357	6.6168	6.6225	143668.0
2008-05-07 08:00:00	AAPL	Stock	6.6254	6.6496	6.6254	6.6304	1759240.0
2008-05-07 08:30:00	AAPL	Stock	6.6314	6.6625	6.6314	6.6429	2205672.0
2008-05-07 09:00:00	AAPL	Stock	6.6461	6.6664	6.6321	6.6471	2300760.0
2008-05-07 09:30:00	AAPL	Stock	6.645	6.6579	6.5989	6.6339	119046872.0
2008-05-07 10:00:00	AAPL	Stock	6.6343	6.6879	6.6196	6.6779	102599868.0
2008-05-07 10:30:00	AAPL	Stock	6.6775	6.7071	6.6714	6.685	82465376.0
2008-05-07 11:00:00	AAPL	Stock	6.6854	6.7214	6.6757	6.6796	78130612.0
2008-05-07 11:30:00	AAPL	Stock	6.6793	6.6804	6.6389	6.6518	68192964.0
2008-05-07 12:00:00	AAPL	Stock	6.6514	6.6839	6.6454	6.6546	48202728.0
2008-05-07 12:30:00	AAPL	Stock	6.6554	6.6704	6.6457	6.6604	31084452.0
2008-05-07 13:00:00	AAPL	Stock	6.6611	6.6646	6.6175	6.6218	61110616.0
2008-05-07 13:30:00	AAPL	Stock	6.6225	6.6271	6.5607	6.5839	89572280.0
2008-05-07 14:00:00	AAPL	Stock	6.5839	6.5979	6.5525	6.5643	71776376.0
2008-05-07 14:30:00	AAPL	Stock	6.5654	6.5679	6.4961	6.5196	120618372.0
2008-05-07 15:00:00	AAPL	Stock	6.5189	6.5339	6.4479	6.4607	112647192.0
2008-05-07 15:30:00	AAPL	Stock	6.4618	6.5357	6.4496	6.5257	141026200.0
2008-05-07 16:00:00	AAPL	Stock	6.5329	6.5988	6.5211	6.5321	14381080.0
2008-05-07 16:30:00	AAPL	Stock	6.5307	6.5314	6.515	6.5161	974988.0
2008-05-07 17:00:00	AAPL	Stock	6.5196	6.5286	6.5143	6.5257	794276.0
2008-05-07 17:30:00	AAPL	Stock	6.5282	6.5286	6.5207	6.5232	247716.0
2008-05-07 18:00:00	AAPL	Stock	6.525	6.5268	6.5221	6.5236	175280.0
2008-05-07 18:30:00	AAPL	Stock	6.5232	6.5246	6.5196	6.5196	378336.0
2008-05-07 19:00:00	AAPL	Stock	6.5196	6.5286	6.5196	6.525	125384.0
2008-05-07 19:30:00	AAPL	Stock	6.5282	6.535	6.5282	6.535	411264.0
2008-05-07 07:00:00	MSFT	Stock	29.77	29.77	29.77	29.77	290.0
2008-05-07 08:00:00	MSFT	Stock	29.65	29.7	29.65	29.65	6648.0
2008-05-07 08:30:00	MSFT	Stock	29.7	29.77	29.7	29.72	5500.0
2008-05-07 09:00:00	MSFT	Stock	29.72	29.77	29.68	29.7	75641.0
2008-05-07 09:30:00	MSFT	Stock	29.71	29.982	29.69	29.93	10181662.0
2008-05-07 10:00:00	MSFT	Stock	29.92	29.93	29.85	29.91	6918245.0
2008-05-07 10:30:00	MSFT	Stock	29.92	30.14	29.91	30.0	9108220.0
2008-05-07 11:00:00	MSFT	Stock	30.01	30.04	29.92	29.92	5464797.0
2008-05-07 11:30:00	MSFT	Stock	29.93	29.93	29.85	29.85	3432696.0
2008-05-07 12:00:00	MSFT	Stock	29.859	29.94	29.85	29.85	4111779.0
2008-05-07 12:30:00	MSFT	Stock	29.85	29.93	29.83	29.88	2587587.0
2008-05-07 13:00:00	MSFT	Stock	29.888	29.9	29.76	29.787	3253770.0
2008-05-07 13:30:00	MSFT	Stock	29.78	29.79	29.51	29.6	6143573.0
2008-05-07 14:00:00	MSFT	Stock	29.6	29.69	29.52	29.55	4087746.0
2008-05-07 14:30:00	MSFT	Stock	29.55	29.59	29.38	29.438	6942290.0
2008-05-07 15:00:00	MSFT	Stock	29.44	29.44	29.22	29.272	6782743.0
2008-05-07 15:30:00	MSFT	Stock	29.275	29.46	29.08	29.19	13247851.0
2008-05-07 16:00:00	MSFT	Stock	29.2	29.708	29.16	29.2	5588296.0
2008-05-07 16:30:00	MSFT	Stock	29.17	29.7	29.17	29.2	30816.0
2008-05-07 17:00:00	MSFT	Stock	29.19	29.24	29.18	29.24	73410.0
2008-05-07 17:30:00	MSFT	Stock	29.23	29.27	29.23	29.24	4068.0
2008-05-07 18:00:00	MSFT	Stock	29.22	29.26	29.22	29.25	2774.0
2008-05-07 18:30:00	MSFT	Stock	29.25	29.25	29.22	29.22	744.0

> showing 50 of 68,713 rows — these rows as CSV

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