PREVIEW / stock_30min / 2008-04-08

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-08.parquet
  size:    1.2 MB
  rows:    68,727
  symbols: 3,280

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-04-08 05:00:00	AAPL	Stock	5.5254	5.5286	5.5179	5.5179	61600.0
2008-04-08 05:30:00	AAPL	Stock	5.5179	5.5179	5.4825	5.495	218400.0
2008-04-08 06:00:00	AAPL	Stock	5.5179	5.5179	5.4861	5.4861	11200.0
2008-04-08 06:30:00	AAPL	Stock	5.5	5.5	5.4911	5.4932	292964.0
2008-04-08 07:00:00	AAPL	Stock	5.49	5.4946	5.4646	5.4679	572040.0
2008-04-08 07:30:00	AAPL	Stock	5.4654	5.4807	5.4639	5.4729	1136016.0
2008-04-08 08:00:00	AAPL	Stock	5.4732	5.4857	5.4682	5.4789	3755416.0
2008-04-08 08:30:00	AAPL	Stock	5.4789	5.4982	5.4789	5.4843	2457420.0
2008-04-08 09:00:00	AAPL	Stock	5.4836	5.4857	5.47	5.4836	4954180.0
2008-04-08 09:30:00	AAPL	Stock	5.4846	5.5275	5.45	5.5157	150760288.0
2008-04-08 10:00:00	AAPL	Stock	5.5161	5.5721	5.4914	5.5504	127728356.0
2008-04-08 10:30:00	AAPL	Stock	5.5507	5.5875	5.5454	5.5625	84488404.0
2008-04-08 11:00:00	AAPL	Stock	5.5629	5.5804	5.5493	5.5607	49160076.0
2008-04-08 11:30:00	AAPL	Stock	5.5607	5.5804	5.5196	5.5336	64041656.0
2008-04-08 12:00:00	AAPL	Stock	5.5336	5.5429	5.5168	5.5293	40226592.0
2008-04-08 12:30:00	AAPL	Stock	5.5282	5.5339	5.51	5.5157	27115060.0
2008-04-08 13:00:00	AAPL	Stock	5.5157	5.525	5.4982	5.5018	34462708.0
2008-04-08 13:30:00	AAPL	Stock	5.5018	5.5271	5.49	5.5139	47763716.0
2008-04-08 14:00:00	AAPL	Stock	5.5139	5.5143	5.44	5.4582	90073452.0
2008-04-08 14:30:00	AAPL	Stock	5.4575	5.485	5.4525	5.4807	76553456.0
2008-04-08 15:00:00	AAPL	Stock	5.4804	5.4811	5.4421	5.4693	56638764.0
2008-04-08 15:30:00	AAPL	Stock	5.4689	5.4814	5.4554	5.4575	95447380.0
2008-04-08 16:00:00	AAPL	Stock	5.4575	5.5099	5.4568	5.4661	29687448.0
2008-04-08 16:30:00	AAPL	Stock	5.4661	5.5764	5.4586	5.4646	5912480.0
2008-04-08 17:00:00	AAPL	Stock	5.4661	5.4714	5.4586	5.4586	543256.0
2008-04-08 17:30:00	AAPL	Stock	5.4589	5.4679	5.4586	5.4679	376572.0
2008-04-08 18:00:00	AAPL	Stock	5.4679	5.4779	5.4671	5.4779	441560.0
2008-04-08 18:30:00	AAPL	Stock	5.4775	5.4775	5.4746	5.4746	201600.0
2008-04-08 19:00:00	AAPL	Stock	5.4704	5.4786	5.4704	5.4786	171304.0
2008-04-08 19:30:00	AAPL	Stock	5.4793	5.4875	5.4789	5.4857	342804.0
2008-04-08 08:00:00	MSFT	Stock	29.05	29.16	28.95	28.97	28420.0
2008-04-08 08:30:00	MSFT	Stock	28.97	29.0	28.97	29.0	6300.0
2008-04-08 09:00:00	MSFT	Stock	29.0	29.0	28.91	28.92	10040.0
2008-04-08 09:30:00	MSFT	Stock	28.94	29.0	28.79	28.795	3407495.0
2008-04-08 10:00:00	MSFT	Stock	28.79	28.83	28.68	28.74	4809832.0
2008-04-08 10:30:00	MSFT	Stock	28.73	28.85	28.71	28.82	2388970.0
2008-04-08 11:00:00	MSFT	Stock	28.815	28.85	28.75	28.81	1741957.0
2008-04-08 11:30:00	MSFT	Stock	28.8	28.83	28.74	28.77	1920427.0
2008-04-08 12:00:00	MSFT	Stock	28.765	28.9	28.72	28.75	1886676.0
2008-04-08 12:30:00	MSFT	Stock	28.76	28.79	28.73	28.73	1691106.0
2008-04-08 13:00:00	MSFT	Stock	28.74	28.8	28.71	28.725	1520521.0
2008-04-08 13:30:00	MSFT	Stock	28.72	28.75	28.68	28.705	2366732.0
2008-04-08 14:00:00	MSFT	Stock	28.7	28.72	28.61	28.65	2846507.0
2008-04-08 14:30:00	MSFT	Stock	28.65	28.8	28.54	28.792	3061892.0
2008-04-08 15:00:00	MSFT	Stock	28.8	28.81	28.73	28.78	2818582.0
2008-04-08 15:30:00	MSFT	Stock	28.77	28.85	28.73	28.79	5916474.0
2008-04-08 16:00:00	MSFT	Stock	28.79	28.79	28.67	28.76	7185783.0
2008-04-08 16:30:00	MSFT	Stock	28.71	29.16	28.71	28.71	194540.0
2008-04-08 17:00:00	MSFT	Stock	28.71	28.71	28.71	28.71	300.0
2008-04-08 17:30:00	MSFT	Stock	28.74	28.75	28.7	28.7	2354.0

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

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