PREVIEW / stock_30min / 2018-04-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-13.parquet
  size:    1.6 MB
  rows:    81,792
  symbols: 2,854

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-04-13 04:00:00	AAPL	Stock	43.4975	43.4975	43.495	43.495	5592.0
2018-04-13 06:00:00	AAPL	Stock	43.58	43.5825	43.58	43.5825	7440.0
2018-04-13 06:30:00	AAPL	Stock	43.5825	43.6025	43.5825	43.6025	1908.0
2018-04-13 07:00:00	AAPL	Stock	43.605	43.6625	43.6	43.6375	66808.0
2018-04-13 07:30:00	AAPL	Stock	43.6375	43.67	43.6275	43.6375	33560.0
2018-04-13 08:00:00	AAPL	Stock	43.6625	43.7475	43.63	43.72	144552.0
2018-04-13 08:30:00	AAPL	Stock	43.73	43.7475	43.705	43.73	82364.0
2018-04-13 09:00:00	AAPL	Stock	43.7375	43.74	43.6875	43.6975	103968.0
2018-04-13 09:30:00	AAPL	Stock	43.69	43.96	43.69	43.8125	13167128.0
2018-04-13 10:00:00	AAPL	Stock	43.81	43.8225	43.475	43.524	8445196.0
2018-04-13 10:30:00	AAPL	Stock	43.5225	43.75	43.4625	43.65	6872104.0
2018-04-13 11:00:00	AAPL	Stock	43.6475	43.83	43.5275	43.7915	6010488.0
2018-04-13 11:30:00	AAPL	Stock	43.79	43.825	43.68	43.8	4528392.0
2018-04-13 12:00:00	AAPL	Stock	43.805	43.8375	43.6675	43.7925	3547880.0
2018-04-13 12:30:00	AAPL	Stock	43.79	43.7925	43.6675	43.775	2766072.0
2018-04-13 13:00:00	AAPL	Stock	43.7775	43.85	43.7472	43.8162	2955420.0
2018-04-13 13:30:00	AAPL	Stock	43.8175	43.87	43.755	43.855	3314740.0
2018-04-13 14:00:00	AAPL	Stock	43.855	43.86	43.675	43.71	4142572.0
2018-04-13 14:30:00	AAPL	Stock	43.71	43.79	43.65	43.695	4176764.0
2018-04-13 15:00:00	AAPL	Stock	43.695	43.695	43.52	43.5618	5883564.0
2018-04-13 15:30:00	AAPL	Stock	43.5575	43.75	43.5275	43.6825	7369364.0
2018-04-13 16:00:00	AAPL	Stock	43.68	43.7375	43.66	43.7175	10788276.0
2018-04-13 16:30:00	AAPL	Stock	43.69	43.7325	43.69	43.7025	27168.0
2018-04-13 17:00:00	AAPL	Stock	43.7	43.7175	43.6925	43.7175	4932.0
2018-04-13 17:30:00	AAPL	Stock	43.705	43.715	43.7025	43.7075	5524.0
2018-04-13 18:00:00	AAPL	Stock	43.725	43.725	43.71	43.71	52632.0
2018-04-13 18:30:00	AAPL	Stock	43.7125	43.7125	43.695	43.695	2244.0
2018-04-13 19:00:00	AAPL	Stock	43.7025	43.7025	43.695	43.695	3600.0
2018-04-13 19:30:00	AAPL	Stock	43.7125	43.7125	43.6925	43.6925	15760.0
2018-04-13 05:00:00	MSFT	Stock	93.6	93.6	93.6	93.6	1018.0
2018-04-13 06:00:00	MSFT	Stock	93.69	93.69	93.68	93.68	332.0
2018-04-13 06:30:00	MSFT	Stock	93.71	93.73	93.71	93.73	1500.0
2018-04-13 07:00:00	MSFT	Stock	93.62	93.86	93.53	93.84	6536.0
2018-04-13 07:30:00	MSFT	Stock	93.8	93.94	93.63	93.79	6642.0
2018-04-13 08:00:00	MSFT	Stock	93.81	94.0	93.78	94.0	7070.0
2018-04-13 08:30:00	MSFT	Stock	94.04	94.13	94.03	94.11	7523.0
2018-04-13 09:00:00	MSFT	Stock	94.08	94.14	94.0	94.05	19472.0
2018-04-13 09:30:00	MSFT	Stock	94.06	94.18	93.24	93.45	2257164.0
2018-04-13 10:00:00	MSFT	Stock	93.44	93.5	92.75	92.84	1431679.0
2018-04-13 10:30:00	MSFT	Stock	92.84	93.34	92.7	93.02	1165506.0
2018-04-13 11:00:00	MSFT	Stock	93.01	93.293	92.7	93.195	1286150.0
2018-04-13 11:30:00	MSFT	Stock	93.19	93.24	92.731	93.052	1012454.0
2018-04-13 12:00:00	MSFT	Stock	93.046	93.21	92.78	93.14	918804.0
2018-04-13 12:30:00	MSFT	Stock	93.15	93.25	92.95	93.225	889294.0
2018-04-13 13:00:00	MSFT	Stock	93.222	93.56	93.17	93.5	898538.0
2018-04-13 13:30:00	MSFT	Stock	93.51	93.566	93.32	93.44	841272.0
2018-04-13 14:00:00	MSFT	Stock	93.445	93.59	93.25	93.413	917230.0
2018-04-13 14:30:00	MSFT	Stock	93.4	93.62	93.18	93.23	1033104.0
2018-04-13 15:00:00	MSFT	Stock	93.24	93.255	92.44	92.62	1941254.0
2018-04-13 15:30:00	MSFT	Stock	92.62	93.36	92.51	93.08	3195110.0

> showing 50 of 81,792 rows — these rows as CSV

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