PREVIEW / stock_30min / 2018-02-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-12.parquet
  size:    1.7 MB
  rows:    85,541
  symbols: 2,894

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
2018-02-12 04:00:00	AAPL	Stock	39.4125	39.85	39.4125	39.7	11052.0
2018-02-12 04:30:00	AAPL	Stock	39.71	39.71	39.7	39.705	10396.0
2018-02-12 05:00:00	AAPL	Stock	39.6225	39.6225	39.5875	39.6	23024.0
2018-02-12 05:30:00	AAPL	Stock	39.555	39.625	39.555	39.6175	5636.0
2018-02-12 06:00:00	AAPL	Stock	39.55	39.7	39.535	39.625	12456.0
2018-02-12 06:30:00	AAPL	Stock	39.605	39.625	39.465	39.4975	26832.0
2018-02-12 07:00:00	AAPL	Stock	39.525	39.625	39.4675	39.6	127976.0
2018-02-12 07:30:00	AAPL	Stock	39.6125	39.7125	39.585	39.68	198452.0
2018-02-12 08:00:00	AAPL	Stock	39.7	39.725	39.1025	39.725	370464.0
2018-02-12 08:30:00	AAPL	Stock	39.72	39.7375	39.5675	39.6	330508.0
2018-02-12 09:00:00	AAPL	Stock	39.5975	39.62	39.25	39.62	509328.0
2018-02-12 09:30:00	AAPL	Stock	39.62	40.075	39.3775	39.895	32006712.0
2018-02-12 10:00:00	AAPL	Stock	39.895	40.1175	39.6925	39.86	18363292.0
2018-02-12 10:30:00	AAPL	Stock	39.855	40.2075	39.755	40.1925	16176496.0
2018-02-12 11:00:00	AAPL	Stock	40.1925	40.3775	40.1375	40.3	15949728.0
2018-02-12 11:30:00	AAPL	Stock	40.3	40.53	40.22	40.5225	12171360.0
2018-02-12 12:00:00	AAPL	Stock	40.5222	40.6915	40.4575	40.657	11813632.0
2018-02-12 12:30:00	AAPL	Stock	40.6575	40.7175	40.54	40.625	9900884.0
2018-02-12 13:00:00	AAPL	Stock	40.6325	40.6705	40.4625	40.655	7635624.0
2018-02-12 13:30:00	AAPL	Stock	40.655	40.7475	40.6	40.7168	6241304.0
2018-02-12 14:00:00	AAPL	Stock	40.7175	40.75	40.625	40.7375	7115608.0
2018-02-12 14:30:00	AAPL	Stock	40.7425	40.8188	40.7025	40.7762	10698920.0
2018-02-12 15:00:00	AAPL	Stock	40.7775	40.9725	40.7275	40.9	12685772.0
2018-02-12 15:30:00	AAPL	Stock	40.9	40.9125	40.59	40.6875	23103160.0
2018-02-12 16:00:00	AAPL	Stock	40.6775	40.73	40.67	40.73	17693264.0
2018-02-12 16:30:00	AAPL	Stock	40.6775	40.725	40.6775	40.715	299476.0
2018-02-12 17:00:00	AAPL	Stock	40.7175	40.725	40.705	40.7225	36696.0
2018-02-12 17:30:00	AAPL	Stock	40.71	40.7225	40.7	40.7125	33624.0
2018-02-12 18:00:00	AAPL	Stock	40.7125	40.7275	40.7	40.7275	28868.0
2018-02-12 18:30:00	AAPL	Stock	40.7275	40.7425	40.685	40.685	27016.0
2018-02-12 19:00:00	AAPL	Stock	40.7	40.7	40.6375	40.675	22620.0
2018-02-12 19:30:00	AAPL	Stock	40.6775	40.6775	40.65	40.6625	40708.0
2018-02-12 04:00:00	MSFT	Stock	87.8	88.96	87.8	88.96	7382.0
2018-02-12 04:30:00	MSFT	Stock	89.06	89.13	89.06	89.13	400.0
2018-02-12 05:00:00	MSFT	Stock	89.32	89.32	89.32	89.32	100.0
2018-02-12 05:30:00	MSFT	Stock	89.32	89.34	89.32	89.34	1000.0
2018-02-12 06:00:00	MSFT	Stock	89.34	89.66	89.11	89.5	2609.0
2018-02-12 06:30:00	MSFT	Stock	89.3	89.3	89.01	89.01	1708.0
2018-02-12 07:00:00	MSFT	Stock	89.19	89.44	89.15	89.4	7528.0
2018-02-12 07:30:00	MSFT	Stock	89.4	89.4	88.98	89.1	16237.0
2018-02-12 08:00:00	MSFT	Stock	89.3	89.34	88.18	89.0	55016.0
2018-02-12 08:30:00	MSFT	Stock	89.0	89.1	88.36	88.79	47254.0
2018-02-12 09:00:00	MSFT	Stock	88.5	88.9	88.18	88.5	42237.0
2018-02-12 09:30:00	MSFT	Stock	88.74	89.3	88.3	88.72	4519254.0
2018-02-12 10:00:00	MSFT	Stock	88.72	89.22	87.93	88.18	2549383.0
2018-02-12 10:30:00	MSFT	Stock	88.21	88.645	87.98	88.355	1869595.0
2018-02-12 11:00:00	MSFT	Stock	88.36	88.87	88.205	88.7	2146402.0
2018-02-12 11:30:00	MSFT	Stock	88.68	89.26	88.53	89.15	2153658.0
2018-02-12 12:00:00	MSFT	Stock	89.15	89.31	88.855	89.15	1619378.0
2018-02-12 12:30:00	MSFT	Stock	89.15	89.155	88.79	88.95	1124102.0

> showing 50 of 85,541 rows — these rows as CSV

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