PREVIEW / etf_30min / 2019-10-11

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-11.parquet
  size:    533 KB
  rows:    18,810

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-10-11 04:00:00	SPY	ETF	294.85	295.29	294.85	295.29	23158.0
2019-10-11 04:30:00	SPY	ETF	295.52	296.0	295.47	296.0	20235.0
2019-10-11 05:00:00	SPY	ETF	296.0	296.32	296.0	296.17	44268.0
2019-10-11 05:30:00	SPY	ETF	296.21	296.62	296.17	296.19	28857.0
2019-10-11 06:00:00	SPY	ETF	296.17	296.41	296.17	296.28	57886.0
2019-10-11 06:30:00	SPY	ETF	296.08	296.28	296.0	296.19	55769.0
2019-10-11 07:00:00	SPY	ETF	296.14	296.72	295.98	296.51	287244.0
2019-10-11 07:30:00	SPY	ETF	296.53	296.71	296.4	296.41	164631.0
2019-10-11 08:00:00	SPY	ETF	296.42	296.65	294.48	296.18	503422.0
2019-10-11 08:30:00	SPY	ETF	296.2	296.44	296.19	296.2	322832.0
2019-10-11 09:00:00	SPY	ETF	296.21	296.29	295.97	296.27	328311.0
2019-10-11 09:30:00	SPY	ETF	296.27	297.75	296.25	297.26	8716891.0
2019-10-11 10:00:00	SPY	ETF	297.29	297.87	297.2601	297.84	5870281.0
2019-10-11 10:30:00	SPY	ETF	297.845	297.96	297.45	297.7	3406272.0
2019-10-11 11:00:00	SPY	ETF	297.69	298.4	297.68	298.34	5247667.0
2019-10-11 11:30:00	SPY	ETF	298.35	298.74	297.61	297.7588	8474571.0
2019-10-11 12:00:00	SPY	ETF	297.76	297.85	297.21	297.51	4862993.0
2019-10-11 12:30:00	SPY	ETF	297.505	297.715	296.1448	297.65	5123780.0
2019-10-11 13:00:00	SPY	ETF	297.63	298.23	297.115	297.55	5508694.0
2019-10-11 13:30:00	SPY	ETF	297.6	298.22	297.32	298.13	3272820.0
2019-10-11 14:00:00	SPY	ETF	298.12	298.31	297.66	298.2	2560245.0
2019-10-11 14:30:00	SPY	ETF	298.2	298.48	298.14	298.29	2510582.0
2019-10-11 15:00:00	SPY	ETF	298.3	298.41	298.07	298.245	5091049.0
2019-10-11 15:30:00	SPY	ETF	298.25	298.64	296.16	296.26	22558824.0
2019-10-11 16:00:00	SPY	ETF	296.26	296.75	293.1826	296.47	12165473.0
2019-10-11 16:30:00	SPY	ETF	296.47	296.97	296.28	296.47	1972154.0
2019-10-11 17:00:00	SPY	ETF	296.5	296.5	296.28	296.49	383451.0
2019-10-11 17:30:00	SPY	ETF	296.49	296.64	296.44	296.6	72893.0
2019-10-11 18:00:00	SPY	ETF	296.6	296.71	296.52	296.65	50284.0
2019-10-11 18:30:00	SPY	ETF	296.61	296.85	296.54	296.74	26005.0
2019-10-11 19:00:00	SPY	ETF	296.75	296.81	296.7	296.78	6677.0
2019-10-11 19:30:00	SPY	ETF	296.72	296.9	296.6099	296.85	34904.0
2019-10-11 04:00:00	QQQ	ETF	189.99	190.56	189.97	190.52	22788.0
2019-10-11 04:30:00	QQQ	ETF	190.53	190.85	190.5	190.8	21825.0
2019-10-11 05:00:00	QQQ	ETF	190.77	191.0	190.77	190.9	27303.0
2019-10-11 05:30:00	QQQ	ETF	190.86	191.16	190.84	190.84	19919.0
2019-10-11 06:00:00	QQQ	ETF	190.88	191.02	190.84	190.88	53377.0
2019-10-11 06:30:00	QQQ	ETF	190.86	190.86	190.7	190.78	35312.0
2019-10-11 07:00:00	QQQ	ETF	190.76	191.25	190.67	191.0	123705.0
2019-10-11 07:30:00	QQQ	ETF	191.0	191.04	190.88	190.89	52333.0
2019-10-11 08:00:00	QQQ	ETF	190.71	191.03	189.49	190.75	136388.0
2019-10-11 08:30:00	QQQ	ETF	190.77	190.93	190.7	190.7	70907.0
2019-10-11 09:00:00	QQQ	ETF	190.73	190.85	190.56	190.85	136492.0
2019-10-11 09:30:00	QQQ	ETF	190.8	191.85	190.8	191.5308	5435382.0
2019-10-11 10:00:00	QQQ	ETF	191.55	192.02	191.55	191.98	2267269.0
2019-10-11 10:30:00	QQQ	ETF	191.99	192.11	191.69	191.94	2054396.0
2019-10-11 11:00:00	QQQ	ETF	191.93	192.22	191.91	192.17	2344089.0
2019-10-11 11:30:00	QQQ	ETF	192.17	192.46	191.73	191.83	3145260.0
2019-10-11 12:00:00	QQQ	ETF	191.84	191.91	191.52	191.77	1292225.0
2019-10-11 12:30:00	QQQ	ETF	191.768	191.99	190.72	191.91	2327361.0

> showing 50 of 18,810 rows — these rows as CSV

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