PREVIEW / etf_30min / 2020-11-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-03.parquet
  size:    574 KB
  rows:    21,576

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
2020-11-03 04:00:00	SPY	ETF	333.61	333.93	333.31	333.9	32501.0
2020-11-03 04:30:00	SPY	ETF	333.73	334.94	333.7	334.65	53904.0
2020-11-03 05:00:00	SPY	ETF	334.76	334.85	334.35	334.8	34439.0
2020-11-03 05:30:00	SPY	ETF	334.88	334.93	334.01	334.05	36222.0
2020-11-03 06:00:00	SPY	ETF	334.13	334.68	333.88	334.08	60128.0
2020-11-03 06:30:00	SPY	ETF	333.99	334.4	333.73	334.4	209651.0
2020-11-03 07:00:00	SPY	ETF	334.31	334.5	333.98	334.2	151655.0
2020-11-03 07:30:00	SPY	ETF	334.06	334.24	333.83	333.87	185618.0
2020-11-03 08:00:00	SPY	ETF	334.3999	334.5	331.4	334.0	339733.0
2020-11-03 08:30:00	SPY	ETF	333.97	334.31	333.53	333.67	147932.0
2020-11-03 09:00:00	SPY	ETF	333.7	334.15	333.64	333.7	234569.0
2020-11-03 09:30:00	SPY	ETF	333.69	335.56	333.17	335.38	6481412.0
2020-11-03 10:00:00	SPY	ETF	335.38	338.035	335.23	337.39	7746864.0
2020-11-03 10:30:00	SPY	ETF	337.4	337.9092	336.75	337.88	5556968.0
2020-11-03 11:00:00	SPY	ETF	337.88	338.25	337.35	337.59	5102157.0
2020-11-03 11:30:00	SPY	ETF	337.585	338.25	336.8	336.91	3830774.0
2020-11-03 12:00:00	SPY	ETF	336.91	337.23	336.43	337.09	2995545.0
2020-11-03 12:30:00	SPY	ETF	337.09	337.2	336.105	336.27	4462759.0
2020-11-03 13:00:00	SPY	ETF	336.28	336.64	336.04	336.21	2960177.0
2020-11-03 13:30:00	SPY	ETF	336.26	336.82	334.84	335.03	4167817.0
2020-11-03 14:00:00	SPY	ETF	335.03	336.18	334.89	335.63	4293713.0
2020-11-03 14:30:00	SPY	ETF	335.65	336.74	335.48	336.35	4673293.0
2020-11-03 15:00:00	SPY	ETF	336.34	336.49	335.39	336.43	6494501.0
2020-11-03 15:30:00	SPY	ETF	336.43	338.0899	335.95	335.97	19971428.0
2020-11-03 16:00:00	SPY	ETF	335.94	336.1642	334.71	334.96	7427061.0
2020-11-03 16:30:00	SPY	ETF	334.96	336.1	334.96	335.95	1321166.0
2020-11-03 17:00:00	SPY	ETF	335.9	336.03	335.65	335.82	82390.0
2020-11-03 17:30:00	SPY	ETF	335.85	336.19	335.85	336.07	151446.0
2020-11-03 18:00:00	SPY	ETF	336.11	338.88	335.63	338.63	591434.0
2020-11-03 18:30:00	SPY	ETF	338.65	339.42	338.17	338.27	353726.0
2020-11-03 19:00:00	SPY	ETF	338.22	339.6	337.5	338.56	331950.0
2020-11-03 19:30:00	SPY	ETF	338.6	338.78	333.74	333.89	810414.0
2020-11-03 04:00:00	QQQ	ETF	272.16	272.29	271.83	272.1	30831.0
2020-11-03 04:30:00	QQQ	ETF	272.11	272.55	272.06	272.28	31183.0
2020-11-03 05:00:00	QQQ	ETF	272.21	272.7	272.16	272.7	14145.0
2020-11-03 05:30:00	QQQ	ETF	272.7	272.7	271.8	271.82	43738.0
2020-11-03 06:00:00	QQQ	ETF	271.9	272.1	271.46	271.67	30684.0
2020-11-03 06:30:00	QQQ	ETF	271.63	271.63	271.0	271.55	120623.0
2020-11-03 07:00:00	QQQ	ETF	271.6	271.95	271.53	271.71	75325.0
2020-11-03 07:30:00	QQQ	ETF	271.66	271.92	271.36	271.44	100222.0
2020-11-03 08:00:00	QQQ	ETF	271.65	272.15	270.21	271.88	205710.0
2020-11-03 08:30:00	QQQ	ETF	271.86	272.23	271.48	271.61	136874.0
2020-11-03 09:00:00	QQQ	ETF	271.6	271.86	271.59	271.82	123018.0
2020-11-03 09:30:00	QQQ	ETF	271.85	273.26	270.84	273.2139	3882029.0
2020-11-03 10:00:00	QQQ	ETF	273.25	276.365	273.1579	275.7182	3236413.0
2020-11-03 10:30:00	QQQ	ETF	275.72	276.52	274.9562	276.47	2098960.0
2020-11-03 11:00:00	QQQ	ETF	276.51	276.82	275.53	275.877	1581699.0
2020-11-03 11:30:00	QQQ	ETF	275.96	276.68	275.34	275.54	1269366.0
2020-11-03 12:00:00	QQQ	ETF	275.55	276.28	275.04	276.22	1205970.0
2020-11-03 12:30:00	QQQ	ETF	276.23	276.29	275.332	275.5471	1082140.0

> showing 50 of 21,576 rows — these rows as CSV

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