PREVIEW / stock_30min / 2007-12-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-19.parquet
  size:    1.2 MB
  rows:    69,302
  symbols: 3,230

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
2007-12-19 05:30:00	AAPL	Stock	6.5286	6.5286	6.5271	6.5271	30800.0
2007-12-19 06:00:00	AAPL	Stock	6.5179	6.5264	6.5	6.5236	33600.0
2007-12-19 06:30:00	AAPL	Stock	6.5286	6.5286	6.5286	6.5286	14000.0
2007-12-19 07:00:00	AAPL	Stock	6.5179	6.5179	6.5179	6.5179	2800.0
2007-12-19 07:30:00	AAPL	Stock	6.5107	6.5325	6.5107	6.5325	58156.0
2007-12-19 08:00:00	AAPL	Stock	6.5318	6.5446	6.5196	6.5411	1214836.0
2007-12-19 08:30:00	AAPL	Stock	6.5393	6.5411	6.52	6.525	734216.0
2007-12-19 09:00:00	AAPL	Stock	6.525	6.5496	6.5204	6.5357	1540476.0
2007-12-19 09:30:00	AAPL	Stock	6.535	6.5746	6.4971	6.56	113952216.0
2007-12-19 10:00:00	AAPL	Stock	6.5604	6.5942	6.5389	6.57	92959216.0
2007-12-19 10:30:00	AAPL	Stock	6.57	6.5714	6.5161	6.5279	69280400.0
2007-12-19 11:00:00	AAPL	Stock	6.5271	6.5282	6.4679	6.4704	72881060.0
2007-12-19 11:30:00	AAPL	Stock	6.4714	6.4989	6.4611	6.475	57695008.0
2007-12-19 12:00:00	AAPL	Stock	6.4755	6.5179	6.4607	6.5136	50253952.0
2007-12-19 12:30:00	AAPL	Stock	6.5139	6.5214	6.4839	6.5107	37659300.0
2007-12-19 13:00:00	AAPL	Stock	6.5104	6.5193	6.4882	6.495	25999848.0
2007-12-19 13:30:00	AAPL	Stock	6.4971	6.5093	6.4707	6.4793	31720696.0
2007-12-19 14:00:00	AAPL	Stock	6.4793	6.5671	6.4771	6.5579	66622052.0
2007-12-19 14:30:00	AAPL	Stock	6.5579	6.5839	6.5525	6.5643	69548500.0
2007-12-19 15:00:00	AAPL	Stock	6.5632	6.5729	6.5386	6.5504	53849600.0
2007-12-19 15:30:00	AAPL	Stock	6.5496	6.5696	6.5357	6.5368	62444536.0
2007-12-19 16:00:00	AAPL	Stock	6.5364	6.5586	6.5314	6.5518	14576324.0
2007-12-19 16:30:00	AAPL	Stock	6.54	6.55	6.5216	6.5496	475552.0
2007-12-19 17:00:00	AAPL	Stock	6.5496	6.5893	6.54	6.5889	1696744.0
2007-12-19 17:30:00	AAPL	Stock	6.5893	6.5982	6.5725	6.5725	886396.0
2007-12-19 18:00:00	AAPL	Stock	6.5768	6.5839	6.54	6.5804	671328.0
2007-12-19 18:30:00	AAPL	Stock	6.5793	6.5821	6.5768	6.5768	109732.0
2007-12-19 19:00:00	AAPL	Stock	6.5793	6.5946	6.5793	6.5893	883932.0
2007-12-19 19:30:00	AAPL	Stock	6.5839	6.5893	6.5821	6.5893	151676.0
2007-12-19 07:00:00	MSFT	Stock	34.5	34.5	34.5	34.5	500.0
2007-12-19 07:30:00	MSFT	Stock	34.67	34.67	34.67	34.67	100.0
2007-12-19 08:00:00	MSFT	Stock	34.68	34.68	34.68	34.68	700.0
2007-12-19 08:30:00	MSFT	Stock	34.74	34.79	34.66	34.71	17310.0
2007-12-19 09:00:00	MSFT	Stock	34.72	34.74	34.65	34.68	36681.0
2007-12-19 09:30:00	MSFT	Stock	34.69	34.99	34.68	34.96	4920211.0
2007-12-19 10:00:00	MSFT	Stock	34.96	35.14	34.77	34.88	5789865.0
2007-12-19 10:30:00	MSFT	Stock	34.89	34.93	34.75	34.86	3344036.0
2007-12-19 11:00:00	MSFT	Stock	34.86	34.87	34.72	34.74	3725436.0
2007-12-19 11:30:00	MSFT	Stock	34.74	34.89	34.7	34.8	2814842.0
2007-12-19 12:00:00	MSFT	Stock	34.8	34.85	34.65	34.688	3343703.0
2007-12-19 12:30:00	MSFT	Stock	34.68	34.69	34.52	34.63	2524857.0
2007-12-19 13:00:00	MSFT	Stock	34.63	34.64	34.41	34.45	2000995.0
2007-12-19 13:30:00	MSFT	Stock	34.445	34.52	34.38	34.49	2486981.0
2007-12-19 14:00:00	MSFT	Stock	34.48	34.8	34.46	34.77	4970774.0
2007-12-19 14:30:00	MSFT	Stock	34.77	34.83	34.67	34.779	5211710.0
2007-12-19 15:00:00	MSFT	Stock	34.77	34.83	34.72	34.79	6469288.0
2007-12-19 15:30:00	MSFT	Stock	34.79	34.82	34.72	34.76	7642824.0
2007-12-19 16:00:00	MSFT	Stock	34.76	34.98	34.705	34.82	2000924.0
2007-12-19 16:30:00	MSFT	Stock	34.79	34.91	34.72	34.89	179891.0
2007-12-19 17:00:00	MSFT	Stock	34.89	34.92	34.79	34.92	1058032.0

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

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