PREVIEW / stock_30min / 2019-07-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-17.parquet
  size:    1.7 MB
  rows:    84,143
  symbols: 2,558

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
2019-07-17 04:00:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	400.0
2019-07-17 05:30:00	AAPL	Stock	51.175	51.22	51.175	51.22	1360.0
2019-07-17 06:00:00	AAPL	Stock	51.1975	51.1975	51.175	51.175	2720.0
2019-07-17 06:30:00	AAPL	Stock	51.175	51.175	51.1325	51.175	9876.0
2019-07-17 07:00:00	AAPL	Stock	51.225	51.2325	51.15	51.1625	22576.0
2019-07-17 07:30:00	AAPL	Stock	51.15	51.1625	51.1025	51.1625	36732.0
2019-07-17 08:00:00	AAPL	Stock	51.1875	51.225	51.0775	51.125	84776.0
2019-07-17 08:30:00	AAPL	Stock	51.1325	51.1325	51.0	51.0175	85536.0
2019-07-17 09:00:00	AAPL	Stock	51.025	51.075	50.9575	51.0575	102996.0
2019-07-17 09:30:00	AAPL	Stock	51.0125	51.165	50.915	51.1325	7973856.0
2019-07-17 10:00:00	AAPL	Stock	51.13	51.1525	50.995	51.075	3420488.0
2019-07-17 10:30:00	AAPL	Stock	51.075	51.19	51.0425	51.1438	3711880.0
2019-07-17 11:00:00	AAPL	Stock	51.1475	51.175	51.1025	51.141	2614660.0
2019-07-17 11:30:00	AAPL	Stock	51.14	51.24	51.115	51.21	2936440.0
2019-07-17 12:00:00	AAPL	Stock	51.2175	51.2475	51.1525	51.175	1805396.0
2019-07-17 12:30:00	AAPL	Stock	51.1775	51.273	51.15	51.255	1984496.0
2019-07-17 13:00:00	AAPL	Stock	51.2575	51.2575	51.16	51.1975	1414380.0
2019-07-17 13:30:00	AAPL	Stock	51.2	51.2275	51.155	51.2212	1416300.0
2019-07-17 14:00:00	AAPL	Stock	51.2225	51.225	51.115	51.1562	1390900.0
2019-07-17 14:30:00	AAPL	Stock	51.155	51.17	51.045	51.085	1951464.0
2019-07-17 15:00:00	AAPL	Stock	51.085	51.09	51.01	51.02	2588824.0
2019-07-17 15:30:00	AAPL	Stock	51.0225	51.045	50.8175	50.82	5955324.0
2019-07-17 16:00:00	AAPL	Stock	50.8375	50.8725	50.705	50.7875	5692536.0
2019-07-17 16:30:00	AAPL	Stock	50.775	50.8375	50.7	50.7222	169596.0
2019-07-17 17:00:00	AAPL	Stock	50.75	50.755	50.7375	50.74	31604.0
2019-07-17 17:30:00	AAPL	Stock	50.74	50.8375	50.74	50.8375	23804.0
2019-07-17 18:00:00	AAPL	Stock	50.7725	50.79	50.7525	50.775	6856.0
2019-07-17 18:30:00	AAPL	Stock	50.7725	50.775	50.76	50.765	15372.0
2019-07-17 19:00:00	AAPL	Stock	50.7625	50.7625	50.7075	50.725	17756.0
2019-07-17 19:30:00	AAPL	Stock	50.725	50.7625	50.7025	50.75	27568.0
2019-07-17 06:30:00	MSFT	Stock	137.34	137.34	137.34	137.34	2054.0
2019-07-17 07:00:00	MSFT	Stock	137.26	137.31	137.2	137.21	3395.0
2019-07-17 07:30:00	MSFT	Stock	137.15	137.21	137.07	137.18	1817.0
2019-07-17 08:00:00	MSFT	Stock	137.11	137.439	137.1	137.24	9343.0
2019-07-17 08:30:00	MSFT	Stock	137.24	137.24	137.0	137.09	5134.0
2019-07-17 09:00:00	MSFT	Stock	137.0	137.65	137.0	137.65	37091.0
2019-07-17 09:30:00	MSFT	Stock	137.72	137.75	137.18	137.53	2215903.0
2019-07-17 10:00:00	MSFT	Stock	137.54	137.93	137.51	137.75	1132518.0
2019-07-17 10:30:00	MSFT	Stock	137.74	137.91	137.13	137.14	1394246.0
2019-07-17 11:00:00	MSFT	Stock	137.15	137.26	136.98	137.06	1004383.0
2019-07-17 11:30:00	MSFT	Stock	137.05	137.255	136.86	137.075	852549.0
2019-07-17 12:00:00	MSFT	Stock	137.08	137.16	136.91	137.01	626870.0
2019-07-17 12:30:00	MSFT	Stock	137.02	137.165	136.9	136.98	715583.0
2019-07-17 13:00:00	MSFT	Stock	136.985	137.13	136.9	137.032	648477.0
2019-07-17 13:30:00	MSFT	Stock	137.04	137.17	136.99	137.17	512994.0
2019-07-17 14:00:00	MSFT	Stock	137.18	137.24	137.0	137.23	529683.0
2019-07-17 14:30:00	MSFT	Stock	137.223	137.41	137.19	137.32	669336.0
2019-07-17 15:00:00	MSFT	Stock	137.315	137.34	137.11	137.12	962247.0
2019-07-17 15:30:00	MSFT	Stock	137.13	137.3	136.22	136.22	3368726.0
2019-07-17 16:00:00	MSFT	Stock	136.22	136.32	135.9	136.0	3184375.0

> showing 50 of 84,143 rows — these rows as CSV

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