PREVIEW / etf_30min / 2019-07-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-19.parquet
  size:    498 KB
  rows:    17,391

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-19 04:00:00	SPY	ETF	299.79	299.97	299.79	299.94	3979.0
2019-07-19 04:30:00	SPY	ETF	299.92	299.93	299.71	299.77	6275.0
2019-07-19 05:00:00	SPY	ETF	299.62	299.69	299.48	299.48	1410.0
2019-07-19 05:30:00	SPY	ETF	299.52	299.52	299.15	299.25	7910.0
2019-07-19 06:00:00	SPY	ETF	299.15	299.29	299.02	299.29	7641.0
2019-07-19 06:30:00	SPY	ETF	299.15	299.23	298.97	299.09	7650.0
2019-07-19 07:00:00	SPY	ETF	299.07	299.28	298.95	299.22	40713.0
2019-07-19 07:30:00	SPY	ETF	299.22	299.47	299.22	299.34	103794.0
2019-07-19 08:00:00	SPY	ETF	299.07	299.88	298.99	299.65	85087.0
2019-07-19 08:30:00	SPY	ETF	299.6	299.74	299.35	299.73	77842.0
2019-07-19 09:00:00	SPY	ETF	299.68	300.08	299.63	300.08	456420.0
2019-07-19 09:30:00	SPY	ETF	300.04	300.07	299.38	299.61	7258551.0
2019-07-19 10:00:00	SPY	ETF	299.6	299.75	299.18	299.44	3439549.0
2019-07-19 10:30:00	SPY	ETF	299.44	299.59	298.91	299.1454	4264790.0
2019-07-19 11:00:00	SPY	ETF	299.15	299.52	299.0525	299.1115	6213067.0
2019-07-19 11:30:00	SPY	ETF	299.12	299.2285	298.44	298.76	4095329.0
2019-07-19 12:00:00	SPY	ETF	298.755	299.24	298.73	299.2	4142341.0
2019-07-19 12:30:00	SPY	ETF	299.21	299.42	299.17	299.31	1160508.0
2019-07-19 13:00:00	SPY	ETF	299.32	299.35	299.0	299.0395	943116.0
2019-07-19 13:30:00	SPY	ETF	299.03	299.1	298.72	299.02	2459050.0
2019-07-19 14:00:00	SPY	ETF	299.02	299.24	298.1802	298.21	3909049.0
2019-07-19 14:30:00	SPY	ETF	298.21	298.49	297.94	298.26	2728188.0
2019-07-19 15:00:00	SPY	ETF	298.2715	298.2725	297.31	297.79	4127314.0
2019-07-19 15:30:00	SPY	ETF	297.795	298.12	296.96	297.12	11464497.0
2019-07-19 16:00:00	SPY	ETF	297.16	297.26	296.62	296.96	7076273.0
2019-07-19 16:30:00	SPY	ETF	296.97	299.4	296.17	296.23	4762342.0
2019-07-19 17:00:00	SPY	ETF	296.28	296.45	296.22	296.44	77511.0
2019-07-19 17:30:00	SPY	ETF	296.42	297.17	296.31	296.48	39784.0
2019-07-19 18:00:00	SPY	ETF	296.48	296.59	296.4	296.51	38125.0
2019-07-19 18:30:00	SPY	ETF	296.56	296.56	296.32	296.34	10398.0
2019-07-19 19:00:00	SPY	ETF	296.35	296.4	296.2	296.2	60761.0
2019-07-19 19:30:00	SPY	ETF	296.31	296.39	296.21	296.36	19739.0
2019-07-19 04:00:00	QQQ	ETF	193.68	193.79	193.67	193.76	6550.0
2019-07-19 04:30:00	QQQ	ETF	193.76	193.76	193.6	193.7	9350.0
2019-07-19 05:00:00	QQQ	ETF	193.6	193.66	193.5	193.54	5600.0
2019-07-19 05:30:00	QQQ	ETF	193.6	193.6	193.34	193.42	8090.0
2019-07-19 06:00:00	QQQ	ETF	193.27	193.34	193.2	193.32	3251.0
2019-07-19 06:30:00	QQQ	ETF	193.31	193.36	193.06	193.09	12816.0
2019-07-19 07:00:00	QQQ	ETF	193.09	193.23	192.97	193.23	67777.0
2019-07-19 07:30:00	QQQ	ETF	193.23	193.36	193.18	193.29	52317.0
2019-07-19 08:00:00	QQQ	ETF	193.28	193.59	192.97	193.47	32394.0
2019-07-19 08:30:00	QQQ	ETF	193.47	193.6	193.3	193.6	48247.0
2019-07-19 09:00:00	QQQ	ETF	193.58	193.98	193.53	193.87	235897.0
2019-07-19 09:30:00	QQQ	ETF	193.83	193.83	193.06	193.25	2520630.0
2019-07-19 10:00:00	QQQ	ETF	193.24	193.37	192.79	192.97	1410232.0
2019-07-19 10:30:00	QQQ	ETF	192.98	193.065	192.46	192.72	1250037.0
2019-07-19 11:00:00	QQQ	ETF	192.73	193.13	192.62	192.81	1060896.0
2019-07-19 11:30:00	QQQ	ETF	192.8164	192.9	192.06	192.35	1815750.0
2019-07-19 12:00:00	QQQ	ETF	192.34	192.76	192.34	192.76	912901.0
2019-07-19 12:30:00	QQQ	ETF	192.76	192.95	192.69	192.78	529146.0

> showing 50 of 17,391 rows — these rows as CSV

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