PREVIEW / stock_30min / 2009-12-04

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-04.parquet
  size:    1.3 MB
  rows:    71,949
  symbols: 3,435

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-04 04:30:00	AAPL	Stock	7.0136	7.0136	7.0136	7.0136	2800.0
2009-12-04 07:00:00	AAPL	Stock	7.0104	7.0107	7.0096	7.0107	28504.0
2009-12-04 07:30:00	AAPL	Stock	7.0039	7.0071	7.0004	7.0004	140000.0
2009-12-04 08:00:00	AAPL	Stock	7.0039	7.0246	6.9911	7.0246	1133216.0
2009-12-04 08:30:00	AAPL	Stock	7.0182	7.1429	7.0161	7.1179	9166584.0
2009-12-04 09:00:00	AAPL	Stock	7.1193	7.1411	7.1179	7.1289	2748060.0
2009-12-04 09:30:00	AAPL	Stock	7.1293	7.1386	7.0929	7.1214	72479456.0
2009-12-04 10:00:00	AAPL	Stock	7.1225	7.1254	7.0764	7.0956	51972508.0
2009-12-04 10:30:00	AAPL	Stock	7.0957	7.0986	7.0382	7.0538	42255892.0
2009-12-04 11:00:00	AAPL	Stock	7.0532	7.0554	7.0136	7.0146	46910836.0
2009-12-04 11:30:00	AAPL	Stock	7.0143	7.0148	6.7957	6.871	193265128.0
2009-12-04 12:00:00	AAPL	Stock	6.8704	6.9164	6.8464	6.8943	76550544.0
2009-12-04 12:30:00	AAPL	Stock	6.8954	6.9204	6.8929	6.9071	43643012.0
2009-12-04 13:00:00	AAPL	Stock	6.9071	6.9111	6.8686	6.8686	31046092.0
2009-12-04 13:30:00	AAPL	Stock	6.8686	6.8893	6.8575	6.8632	40492256.0
2009-12-04 14:00:00	AAPL	Stock	6.8629	6.875	6.8436	6.8645	40329632.0
2009-12-04 14:30:00	AAPL	Stock	6.8643	6.9057	6.8643	6.9039	43117900.0
2009-12-04 15:00:00	AAPL	Stock	6.9046	6.9279	6.8904	6.91	52265136.0
2009-12-04 15:30:00	AAPL	Stock	6.91	6.9286	6.8957	6.9043	61742996.0
2009-12-04 16:00:00	AAPL	Stock	6.9032	6.9423	6.9032	6.9143	8821372.0
2009-12-04 16:30:00	AAPL	Stock	6.9084	6.915	6.9043	6.915	471800.0
2009-12-04 17:00:00	AAPL	Stock	6.9121	6.9154	6.9089	6.91	186564.0
2009-12-04 17:30:00	AAPL	Stock	6.9107	6.9139	6.9096	6.9104	128632.0
2009-12-04 18:00:00	AAPL	Stock	6.9104	6.9129	6.9043	6.9107	403928.0
2009-12-04 18:30:00	AAPL	Stock	6.9111	6.9154	6.9107	6.9154	37800.0
2009-12-04 19:00:00	AAPL	Stock	6.9114	6.9154	6.9111	6.9125	43176.0
2009-12-04 19:30:00	AAPL	Stock	6.915	6.9161	6.9132	6.9154	138460.0
2009-12-04 08:00:00	MSFT	Stock	29.85	29.85	29.85	29.85	500.0
2009-12-04 08:30:00	MSFT	Stock	29.8	30.1	29.8	30.08	151161.0
2009-12-04 09:00:00	MSFT	Stock	30.08	30.17	30.02	30.07	343500.0
2009-12-04 09:30:00	MSFT	Stock	30.07	30.28	30.0	30.27	7124826.0
2009-12-04 10:00:00	MSFT	Stock	30.27	30.37	30.27	30.332	5436033.0
2009-12-04 10:30:00	MSFT	Stock	30.33	30.33	30.22	30.24	3789742.0
2009-12-04 11:00:00	MSFT	Stock	30.245	30.27	30.05	30.06	4563031.0
2009-12-04 11:30:00	MSFT	Stock	30.05	30.1	29.85	29.97	9090537.0
2009-12-04 12:00:00	MSFT	Stock	29.97	30.07	29.94	30.02	3028700.0
2009-12-04 12:30:00	MSFT	Stock	30.02	30.09	29.95	29.95	2295958.0
2009-12-04 13:00:00	MSFT	Stock	29.95	30.03	29.91	29.93	2433882.0
2009-12-04 13:30:00	MSFT	Stock	29.94	29.97	29.87	29.9	2467394.0
2009-12-04 14:00:00	MSFT	Stock	29.92	29.94	29.83	29.897	3350219.0
2009-12-04 14:30:00	MSFT	Stock	29.9	29.99	29.84	29.98	3071777.0
2009-12-04 15:00:00	MSFT	Stock	29.97	30.11	29.94	30.01	3346039.0
2009-12-04 15:30:00	MSFT	Stock	30.011	30.07	29.96	29.98	5642749.0
2009-12-04 16:00:00	MSFT	Stock	29.98	30.118	29.98	30.063	1476367.0
2009-12-04 16:30:00	MSFT	Stock	30.005	30.005	29.97	29.98	9930.0
2009-12-04 17:00:00	MSFT	Stock	29.96	30.0	29.96	30.0	200.0
2009-12-04 17:30:00	MSFT	Stock	30.0	30.0	29.87	29.87	1100.0
2009-12-04 18:00:00	MSFT	Stock	29.87	29.87	29.85	29.85	1021.0
2009-12-04 19:00:00	MSFT	Stock	29.92	29.97	29.9	29.96	2300.0
2009-12-04 19:30:00	MSFT	Stock	29.96	29.98	29.96	29.98	1999.0

> showing 50 of 71,949 rows — these rows as CSV

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