PREVIEW / stock_30min / 2009-01-15

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-15.parquet
  size:    1.2 MB
  rows:    68,380
  symbols: 3,314

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-15 04:00:00	AAPL	Stock	2.84	2.8507	2.84	2.84	33600.0
2009-01-15 05:00:00	AAPL	Stock	2.8218	2.8218	2.8075	2.8075	22400.0
2009-01-15 05:30:00	AAPL	Stock	2.825	2.825	2.825	2.825	14000.0
2009-01-15 06:00:00	AAPL	Stock	2.8125	2.8125	2.8125	2.8125	2800.0
2009-01-15 06:30:00	AAPL	Stock	2.8196	2.8214	2.7989	2.8043	237720.0
2009-01-15 07:00:00	AAPL	Stock	2.7982	2.825	2.7868	2.8143	1663648.0
2009-01-15 07:30:00	AAPL	Stock	2.8121	2.8536	2.8036	2.8321	2847684.0
2009-01-15 08:00:00	AAPL	Stock	2.8321	2.8446	2.8079	2.8293	11689664.0
2009-01-15 08:30:00	AAPL	Stock	2.8286	2.9239	2.8264	2.9175	38886456.0
2009-01-15 09:00:00	AAPL	Stock	2.9179	2.9221	2.8393	2.8782	39397064.0
2009-01-15 09:30:00	AAPL	Stock	2.8775	2.9496	2.8589	2.9057	402487064.0
2009-01-15 10:00:00	AAPL	Stock	2.905	2.9146	2.8664	2.9025	196085428.0
2009-01-15 10:30:00	AAPL	Stock	2.9021	2.9152	2.8625	2.89	142370732.0
2009-01-15 11:00:00	AAPL	Stock	2.8904	2.9089	2.8825	2.8986	94373244.0
2009-01-15 11:30:00	AAPL	Stock	2.8989	2.9129	2.8857	2.9018	75581688.0
2009-01-15 12:00:00	AAPL	Stock	2.9014	2.9143	2.8925	2.8993	57533280.0
2009-01-15 12:30:00	AAPL	Stock	2.8989	2.9243	2.8929	2.9221	70628628.0
2009-01-15 13:00:00	AAPL	Stock	2.9225	2.9361	2.9161	2.9289	73924396.0
2009-01-15 13:30:00	AAPL	Stock	2.9293	2.9914	2.9261	2.9829	112157360.0
2009-01-15 14:00:00	AAPL	Stock	2.9829	3.0043	2.9482	2.965	133504392.0
2009-01-15 14:30:00	AAPL	Stock	2.965	2.9736	2.95	2.9611	114100196.0
2009-01-15 15:00:00	AAPL	Stock	2.9607	2.9854	2.9561	2.9658	104222216.0
2009-01-15 15:30:00	AAPL	Stock	2.9654	2.9846	2.9396	2.9793	122854760.0
2009-01-15 16:00:00	AAPL	Stock	2.9775	2.9846	2.9256	2.9814	18727912.0
2009-01-15 16:30:00	AAPL	Stock	2.9814	2.993	2.9764	2.9793	4057760.0
2009-01-15 17:00:00	AAPL	Stock	2.9811	2.9821	2.9216	2.9689	350532.0
2009-01-15 17:30:00	AAPL	Stock	2.9732	2.9818	2.9732	2.9818	173880.0
2009-01-15 18:00:00	AAPL	Stock	2.9818	2.9893	2.9771	2.9786	11351564.0
2009-01-15 18:30:00	AAPL	Stock	2.9839	2.9879	2.9804	2.9804	52640.0
2009-01-15 19:00:00	AAPL	Stock	2.9807	2.9811	2.9786	2.9786	56280.0
2009-01-15 19:30:00	AAPL	Stock	2.9779	2.9911	2.9779	2.9911	99372.0
2009-01-15 07:00:00	MSFT	Stock	19.18	19.18	19.01	19.01	600.0
2009-01-15 07:30:00	MSFT	Stock	19.01	19.02	19.0	19.0	2668.0
2009-01-15 08:00:00	MSFT	Stock	19.0	19.07	19.0	19.0	10709.0
2009-01-15 08:30:00	MSFT	Stock	19.04	19.14	19.03	19.11	12443.0
2009-01-15 09:00:00	MSFT	Stock	19.11	19.11	19.08	19.09	24818.0
2009-01-15 09:30:00	MSFT	Stock	19.1	19.31	18.64	18.71	10590884.0
2009-01-15 10:00:00	MSFT	Stock	18.71	18.88	18.53	18.58	11929803.0
2009-01-15 10:30:00	MSFT	Stock	18.576	18.71	18.54	18.61	6311080.0
2009-01-15 11:00:00	MSFT	Stock	18.62	18.68	18.52	18.68	5850807.0
2009-01-15 11:30:00	MSFT	Stock	18.67	18.9	18.64	18.77	4324499.0
2009-01-15 12:00:00	MSFT	Stock	18.77	18.78	18.6	18.709	3836604.0
2009-01-15 12:30:00	MSFT	Stock	18.709	18.77	18.62	18.73	2973358.0
2009-01-15 13:00:00	MSFT	Stock	18.74	18.9	18.73	18.828	3831120.0
2009-01-15 13:30:00	MSFT	Stock	18.82	18.97	18.81	18.95	6205628.0
2009-01-15 14:00:00	MSFT	Stock	18.95	19.13	18.89	19.1	6550434.0
2009-01-15 14:30:00	MSFT	Stock	19.1	19.28	19.02	19.14	6490155.0
2009-01-15 15:00:00	MSFT	Stock	19.13	19.29	18.9	19.17	5614013.0
2009-01-15 15:30:00	MSFT	Stock	19.16	19.27	18.92	19.27	11404035.0
2009-01-15 16:00:00	MSFT	Stock	19.25	19.27	18.873	19.26	6734366.0

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

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