PREVIEW / stock_30min / 2009-12-17

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-17.parquet
  size:    1.3 MB
  rows:    72,110
  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-17 04:00:00	AAPL	Stock	6.9589	6.9589	6.9589	6.9589	2800.0
2009-12-17 04:30:00	AAPL	Stock	6.9318	6.9318	6.9304	6.9304	8400.0
2009-12-17 07:00:00	AAPL	Stock	6.9286	6.9386	6.9214	6.9386	22400.0
2009-12-17 07:30:00	AAPL	Stock	6.9311	6.9311	6.9196	6.9196	50400.0
2009-12-17 08:00:00	AAPL	Stock	6.9393	6.9429	6.9075	6.9286	713692.0
2009-12-17 08:30:00	AAPL	Stock	6.9236	6.9284	6.9071	6.9268	491092.0
2009-12-17 09:00:00	AAPL	Stock	6.9214	6.9411	6.9214	6.9411	356804.0
2009-12-17 09:30:00	AAPL	Stock	6.9329	6.965	6.8879	6.8918	49697816.0
2009-12-17 10:00:00	AAPL	Stock	6.8907	6.9071	6.8629	6.8832	80030664.0
2009-12-17 10:30:00	AAPL	Stock	6.8829	6.8982	6.8536	6.8932	36836268.0
2009-12-17 11:00:00	AAPL	Stock	6.8936	6.9164	6.8932	6.9054	27686764.0
2009-12-17 11:30:00	AAPL	Stock	6.9046	6.9054	6.8815	6.8921	18203920.0
2009-12-17 12:00:00	AAPL	Stock	6.8921	6.8936	6.8711	6.8768	15626100.0
2009-12-17 12:30:00	AAPL	Stock	6.8768	6.8793	6.8539	6.8735	21211904.0
2009-12-17 13:00:00	AAPL	Stock	6.8736	6.8804	6.8657	6.8779	14078624.0
2009-12-17 13:30:00	AAPL	Stock	6.8775	6.8829	6.8661	6.8789	11594716.0
2009-12-17 14:00:00	AAPL	Stock	6.8789	6.8879	6.8679	6.8796	13393856.0
2009-12-17 14:30:00	AAPL	Stock	6.8796	6.8857	6.8707	6.8786	11938780.0
2009-12-17 15:00:00	AAPL	Stock	6.8791	6.8875	6.8679	6.8682	15574356.0
2009-12-17 15:30:00	AAPL	Stock	6.8682	6.8857	6.8489	6.8489	43020180.0
2009-12-17 16:00:00	AAPL	Stock	6.8489	6.9654	6.8214	6.8929	19048624.0
2009-12-17 16:30:00	AAPL	Stock	6.8675	6.9664	6.8521	6.8929	2359560.0
2009-12-17 17:00:00	AAPL	Stock	6.8946	6.9	6.8925	6.8943	914480.0
2009-12-17 17:30:00	AAPL	Stock	6.8929	6.9	6.8911	6.8929	625716.0
2009-12-17 18:00:00	AAPL	Stock	6.8932	6.9	6.8521	6.9	933548.0
2009-12-17 18:30:00	AAPL	Stock	6.9018	6.9036	6.8982	6.9025	187292.0
2009-12-17 19:00:00	AAPL	Stock	6.9018	6.9025	6.8982	6.9	59864.0
2009-12-17 19:30:00	AAPL	Stock	6.9	6.9021	6.8929	6.8946	145824.0
2009-12-17 05:30:00	MSFT	Stock	29.99	29.99	29.99	29.99	100.0
2009-12-17 07:00:00	MSFT	Stock	30.04	30.04	30.04	30.04	200.0
2009-12-17 07:30:00	MSFT	Stock	29.91	29.95	29.86	29.86	4530.0
2009-12-17 08:00:00	MSFT	Stock	29.98	29.98	29.95	29.97	4175.0
2009-12-17 08:30:00	MSFT	Stock	29.98	29.98	29.95	29.95	2340.0
2009-12-17 09:00:00	MSFT	Stock	29.99	29.99	29.95	29.96	6185.0
2009-12-17 09:30:00	MSFT	Stock	29.96	29.96	29.78	29.78	5668206.0
2009-12-17 10:00:00	MSFT	Stock	29.78	29.86	29.705	29.781	4619263.0
2009-12-17 10:30:00	MSFT	Stock	29.79	29.79	29.7	29.76	3358338.0
2009-12-17 11:00:00	MSFT	Stock	29.77	29.79	29.7	29.71	2995935.0
2009-12-17 11:30:00	MSFT	Stock	29.7	29.74	29.63	29.67	3120500.0
2009-12-17 12:00:00	MSFT	Stock	29.675	29.68	29.6	29.605	1786306.0
2009-12-17 12:30:00	MSFT	Stock	29.61	29.65	29.6	29.617	1730146.0
2009-12-17 13:00:00	MSFT	Stock	29.613	29.678	29.61	29.65	1127554.0
2009-12-17 13:30:00	MSFT	Stock	29.658	29.66	29.57	29.6	1900838.0
2009-12-17 14:00:00	MSFT	Stock	29.6	29.64	29.6	29.63	1339122.0
2009-12-17 14:30:00	MSFT	Stock	29.62	29.69	29.61	29.65	2001521.0
2009-12-17 15:00:00	MSFT	Stock	29.65	29.72	29.62	29.7	2886749.0
2009-12-17 15:30:00	MSFT	Stock	29.71	29.75	29.6	29.62	6594751.0
2009-12-17 16:00:00	MSFT	Stock	29.6	30.1	29.53	29.68	3368744.0
2009-12-17 16:30:00	MSFT	Stock	29.717	29.72	29.6	29.67	76473.0
2009-12-17 17:00:00	MSFT	Stock	29.67	29.73	29.67	29.73	4770.0

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

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