PREVIEW / stock_30min / 2009-12-10

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-10.parquet
  size:    1.3 MB
  rows:    72,283
  symbols: 3,427

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
2009-12-10 07:00:00	AAPL	Stock	7.0918	7.1	7.0764	7.0964	176260.0
2009-12-10 07:30:00	AAPL	Stock	7.0982	7.1429	7.0982	7.1189	913080.0
2009-12-10 08:00:00	AAPL	Stock	7.1232	7.1277	7.1043	7.1157	2578828.0
2009-12-10 08:30:00	AAPL	Stock	7.1146	7.1375	7.1125	7.1196	3190124.0
2009-12-10 09:00:00	AAPL	Stock	7.1204	7.1282	7.1114	7.1246	2409960.0
2009-12-10 09:30:00	AAPL	Stock	7.1246	7.1321	7.0425	7.0618	115655148.0
2009-12-10 10:00:00	AAPL	Stock	7.0618	7.0946	7.0464	7.0761	49970704.0
2009-12-10 10:30:00	AAPL	Stock	7.0761	7.0868	7.0432	7.0539	37687468.0
2009-12-10 11:00:00	AAPL	Stock	7.0536	7.0821	7.0479	7.07	25786824.0
2009-12-10 11:30:00	AAPL	Stock	7.0707	7.0818	7.0671	7.0696	15865864.0
2009-12-10 12:00:00	AAPL	Stock	7.0675	7.0757	7.0418	7.0464	22912176.0
2009-12-10 12:30:00	AAPL	Stock	7.0461	7.0639	7.0257	7.0593	31139024.0
2009-12-10 13:00:00	AAPL	Stock	7.0593	7.0639	7.0289	7.0332	23914744.0
2009-12-10 13:30:00	AAPL	Stock	7.0339	7.0504	7.0311	7.04	16344496.0
2009-12-10 14:00:00	AAPL	Stock	7.04	7.0464	7.0261	7.0336	25793404.0
2009-12-10 14:30:00	AAPL	Stock	7.0336	7.0379	7.0043	7.0186	28492800.0
2009-12-10 15:00:00	AAPL	Stock	7.0179	7.0418	7.0139	7.0182	28295176.0
2009-12-10 15:30:00	AAPL	Stock	7.0191	7.0318	7.0054	7.0214	37366168.0
2009-12-10 16:00:00	AAPL	Stock	7.0214	7.0575	7.0136	7.0154	8946896.0
2009-12-10 16:30:00	AAPL	Stock	7.0143	7.0565	7.0132	7.015	4805612.0
2009-12-10 17:00:00	AAPL	Stock	7.015	7.025	7.0143	7.0196	399084.0
2009-12-10 17:30:00	AAPL	Stock	7.0179	7.0246	6.9337	7.0229	141400.0
2009-12-10 18:00:00	AAPL	Stock	7.0189	7.0257	7.0154	7.025	335384.0
2009-12-10 18:30:00	AAPL	Stock	7.0223	7.0225	7.0223	7.0225	26992.0
2009-12-10 19:00:00	AAPL	Stock	7.0225	7.0264	7.0225	7.0257	93660.0
2009-12-10 19:30:00	AAPL	Stock	7.0254	7.0268	7.0243	7.0268	116032.0
2009-12-10 20:00:00	AAPL	Stock	7.0707	7.0707	7.0707	7.0707	2800.0
2009-12-10 07:30:00	MSFT	Stock	29.72	29.72	29.7	29.72	13725.0
2009-12-10 08:00:00	MSFT	Stock	29.72	29.79	29.72	29.75	17650.0
2009-12-10 08:30:00	MSFT	Stock	29.82	29.83	29.74	29.74	2505.0
2009-12-10 09:00:00	MSFT	Stock	29.75	29.79	29.66	29.7	42974.0
2009-12-10 09:30:00	MSFT	Stock	29.71	29.9	29.66	29.77	5384636.0
2009-12-10 10:00:00	MSFT	Stock	29.77	29.91	29.76	29.89	3919079.0
2009-12-10 10:30:00	MSFT	Stock	29.895	29.92	29.85	29.86	1944494.0
2009-12-10 11:00:00	MSFT	Stock	29.86	29.92	29.84	29.91	2254494.0
2009-12-10 11:30:00	MSFT	Stock	29.92	29.94	29.89	29.915	1593804.0
2009-12-10 12:00:00	MSFT	Stock	29.91	29.91	29.85	29.86	1566127.0
2009-12-10 12:30:00	MSFT	Stock	29.86	29.92	29.84	29.911	1764158.0
2009-12-10 13:00:00	MSFT	Stock	29.92	29.93	29.795	29.85	4404725.0
2009-12-10 13:30:00	MSFT	Stock	29.851	29.88	29.84	29.87	1712158.0
2009-12-10 14:00:00	MSFT	Stock	29.88	29.93	29.85	29.915	1210317.0
2009-12-10 14:30:00	MSFT	Stock	29.92	29.95	29.827	29.924	2292450.0
2009-12-10 15:00:00	MSFT	Stock	29.92	29.94	29.87	29.9	4297884.0
2009-12-10 15:30:00	MSFT	Stock	29.9	29.96	29.86	29.87	6194577.0
2009-12-10 16:00:00	MSFT	Stock	29.88	29.916	29.8	29.8	3726559.0
2009-12-10 16:30:00	MSFT	Stock	29.904	29.904	29.87	29.87	29899.0
2009-12-10 17:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	279.0
2009-12-10 17:30:00	MSFT	Stock	29.87	29.87	29.87	29.87	100.0
2009-12-10 18:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	19406.0
2009-12-10 19:00:00	MSFT	Stock	29.89	29.89	29.89	29.89	100.0

> showing 50 of 72,283 rows — these rows as CSV

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