PREVIEW / stock_30min / 2009-01-21

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-21.parquet
  size:    1.2 MB
  rows:    67,738
  symbols: 3,308

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-01-21 06:30:00	AAPL	Stock	2.8375	2.8375	2.8375	2.8375	18200.0
2009-01-21 07:00:00	AAPL	Stock	2.8375	2.8489	2.8239	2.8239	197624.0
2009-01-21 08:00:00	AAPL	Stock	2.8282	2.8357	2.8239	2.8304	841008.0
2009-01-21 08:30:00	AAPL	Stock	2.8304	2.8464	2.8286	2.8432	1279880.0
2009-01-21 09:00:00	AAPL	Stock	2.8436	2.8475	2.8371	2.8393	1525412.0
2009-01-21 09:30:00	AAPL	Stock	2.8375	2.9143	2.8325	2.8893	111643784.0
2009-01-21 10:00:00	AAPL	Stock	2.8914	2.8989	2.8625	2.8646	69652408.0
2009-01-21 10:30:00	AAPL	Stock	2.8639	2.8721	2.8482	2.8511	58442916.0
2009-01-21 11:00:00	AAPL	Stock	2.8511	2.8696	2.8493	2.8643	40412540.0
2009-01-21 11:30:00	AAPL	Stock	2.865	2.8696	2.8429	2.8607	50704052.0
2009-01-21 12:00:00	AAPL	Stock	2.8607	2.8839	2.8557	2.8654	32458216.0
2009-01-21 12:30:00	AAPL	Stock	2.8654	2.8743	2.8571	2.8689	27807024.0
2009-01-21 13:00:00	AAPL	Stock	2.8682	2.8836	2.8646	2.8657	28967512.0
2009-01-21 13:30:00	AAPL	Stock	2.8661	2.89	2.8632	2.8761	42149268.0
2009-01-21 14:00:00	AAPL	Stock	2.8761	2.8832	2.8621	2.8789	36938524.0
2009-01-21 14:30:00	AAPL	Stock	2.8791	2.9082	2.8771	2.9079	59248280.0
2009-01-21 15:00:00	AAPL	Stock	2.9082	2.9336	2.8975	2.9071	86776200.0
2009-01-21 15:30:00	AAPL	Stock	2.9071	2.96	2.905	2.9586	133342216.0
2009-01-21 16:00:00	AAPL	Stock	2.9571	2.9768	2.8888	2.96	27081964.0
2009-01-21 16:30:00	AAPL	Stock	2.9554	3.3107	2.9143	3.21	187062680.0
2009-01-21 17:00:00	AAPL	Stock	3.2093	3.2232	3.1629	3.215	50979516.0
2009-01-21 17:30:00	AAPL	Stock	3.2175	3.2296	2.8575	3.2111	18871356.0
2009-01-21 18:00:00	AAPL	Stock	3.2107	3.2411	2.9582	3.2393	15524572.0
2009-01-21 18:30:00	AAPL	Stock	3.24	3.2411	3.2257	3.2286	2015692.0
2009-01-21 19:00:00	AAPL	Stock	3.2293	3.2321	3.2232	3.2286	1902124.0
2009-01-21 19:30:00	AAPL	Stock	3.2271	3.2407	3.225	3.2393	2166864.0
2009-01-21 07:00:00	MSFT	Stock	18.7	18.7	18.7	18.7	100.0
2009-01-21 08:00:00	MSFT	Stock	18.7	18.7	18.61	18.7	10810.0
2009-01-21 08:30:00	MSFT	Stock	18.7	18.7	18.67	18.7	22950.0
2009-01-21 09:00:00	MSFT	Stock	18.7	18.87	18.65	18.87	93228.0
2009-01-21 09:30:00	MSFT	Stock	18.87	19.1	18.84	19.0	7479022.0
2009-01-21 10:00:00	MSFT	Stock	19.0	19.06	18.73	18.75	5497708.0
2009-01-21 10:30:00	MSFT	Stock	18.74	18.81	18.46	18.53	5663869.0
2009-01-21 11:00:00	MSFT	Stock	18.53	18.66	18.51	18.657	3223347.0
2009-01-21 11:30:00	MSFT	Stock	18.66	18.79	18.64	18.757	3992618.0
2009-01-21 12:00:00	MSFT	Stock	18.76	18.892	18.72	18.82	3198616.0
2009-01-21 12:30:00	MSFT	Stock	18.82	18.9	18.79	18.89	2751537.0
2009-01-21 13:00:00	MSFT	Stock	18.89	18.95	18.8	18.84	3259321.0
2009-01-21 13:30:00	MSFT	Stock	18.84	19.01	18.84	19.01	2958051.0
2009-01-21 14:00:00	MSFT	Stock	19.01	19.02	18.92	18.99	3337590.0
2009-01-21 14:30:00	MSFT	Stock	18.98	19.13	18.98	19.13	3988129.0
2009-01-21 15:00:00	MSFT	Stock	19.13	19.215	19.09	19.14	4983950.0
2009-01-21 15:30:00	MSFT	Stock	19.13	19.44	19.1	19.42	10923221.0
2009-01-21 16:00:00	MSFT	Stock	19.44	19.45	18.754	19.41	5841455.0
2009-01-21 16:30:00	MSFT	Stock	19.39	19.57	19.38	19.45	53462.0
2009-01-21 17:00:00	MSFT	Stock	19.49	19.57	19.45	19.45	22557.0
2009-01-21 17:30:00	MSFT	Stock	18.72	19.55	18.72	19.5	28075.0
2009-01-21 18:00:00	MSFT	Stock	19.38	19.54	19.38	19.53	41436.0
2009-01-21 18:30:00	MSFT	Stock	19.52	19.52	19.43	19.5	8119.0
2009-01-21 19:00:00	MSFT	Stock	19.5	19.52	19.47	19.47	1912.0

> showing 50 of 67,738 rows — these rows as CSV

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