PREVIEW / etf_30min / 2020-11-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-18.parquet
  size:    586 KB
  rows:    21,910

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-18 04:00:00	SPY	ETF	360.17	361.04	360.17	361.04	19589.0
2020-11-18 04:30:00	SPY	ETF	360.91	361.0	360.86	361.0	5263.0
2020-11-18 05:00:00	SPY	ETF	361.05	361.7	361.02	361.7	15034.0
2020-11-18 05:30:00	SPY	ETF	361.48	361.51	361.35	361.42	6214.0
2020-11-18 06:00:00	SPY	ETF	361.43	361.73	361.34	361.41	21987.0
2020-11-18 06:30:00	SPY	ETF	361.4	361.89	361.27	361.55	60026.0
2020-11-18 07:00:00	SPY	ETF	361.57	362.02	361.55	362.01	67743.0
2020-11-18 07:30:00	SPY	ETF	362.01	362.21	361.61	361.76	182970.0
2020-11-18 08:00:00	SPY	ETF	361.6999	362.21	358.91	361.36	126857.0
2020-11-18 08:30:00	SPY	ETF	361.35	361.45	361.05	361.3898	121891.0
2020-11-18 09:00:00	SPY	ETF	361.34	361.45	360.86	360.92	242456.0
2020-11-18 09:30:00	SPY	ETF	360.91	361.33	360.31	360.61	5212173.0
2020-11-18 10:00:00	SPY	ETF	360.6	361.18	360.545	361.15	2929916.0
2020-11-18 10:30:00	SPY	ETF	361.13	361.32	360.73	361.12	2583695.0
2020-11-18 11:00:00	SPY	ETF	361.12	361.5	360.98	361.22	2171694.0
2020-11-18 11:30:00	SPY	ETF	361.23	361.27	360.81	361.21	1884261.0
2020-11-18 12:00:00	SPY	ETF	361.205	361.5	361.0	361.135	2009616.0
2020-11-18 12:30:00	SPY	ETF	361.14	361.26	360.67	360.77	1447228.0
2020-11-18 13:00:00	SPY	ETF	360.76	361.04	360.165	360.1677	3202027.0
2020-11-18 13:30:00	SPY	ETF	360.16	360.55	359.32	359.84	7245849.0
2020-11-18 14:00:00	SPY	ETF	359.83	360.15	358.67	359.05	3876998.0
2020-11-18 14:30:00	SPY	ETF	359.05	359.88	358.88	359.46	2883404.0
2020-11-18 15:00:00	SPY	ETF	359.47	360.06	358.875	358.99	5790545.0
2020-11-18 15:30:00	SPY	ETF	358.98	359.11	356.24	356.29	15576249.0
2020-11-18 16:00:00	SPY	ETF	356.28	356.87	355.86	356.09	8434784.0
2020-11-18 16:30:00	SPY	ETF	356.12	356.28	355.59	355.92	1237549.0
2020-11-18 17:00:00	SPY	ETF	355.87	356.28	355.86	355.96	1694096.0
2020-11-18 17:30:00	SPY	ETF	355.93	356.28	355.88	356.01	196649.0
2020-11-18 18:00:00	SPY	ETF	356.03	356.55	356.03	356.3	124934.0
2020-11-18 18:30:00	SPY	ETF	356.37	356.68	356.14	356.21	56536.0
2020-11-18 19:00:00	SPY	ETF	356.12	356.44	355.32	355.6	90270.0
2020-11-18 19:30:00	SPY	ETF	355.76	356.2	355.65	355.87	70657.0
2020-11-18 04:00:00	QQQ	ETF	292.33	292.73	292.25	292.69	13714.0
2020-11-18 04:30:00	QQQ	ETF	292.67	292.67	292.44	292.63	6402.0
2020-11-18 05:00:00	QQQ	ETF	292.63	293.25	292.63	293.0	10989.0
2020-11-18 05:30:00	QQQ	ETF	292.89	293.0	292.82	292.97	9667.0
2020-11-18 06:00:00	QQQ	ETF	292.98	293.22	292.71	292.83	20461.0
2020-11-18 06:30:00	QQQ	ETF	292.91	292.91	292.35	292.54	67128.0
2020-11-18 07:00:00	QQQ	ETF	292.49	292.85	292.36	292.79	173141.0
2020-11-18 07:30:00	QQQ	ETF	292.82	292.85	292.53	292.6	45711.0
2020-11-18 08:00:00	QQQ	ETF	292.5499	292.86	290.88	292.45	119941.0
2020-11-18 08:30:00	QQQ	ETF	292.39	292.57	292.19	292.3	93327.0
2020-11-18 09:00:00	QQQ	ETF	292.29	292.34	291.5	291.75	234009.0
2020-11-18 09:30:00	QQQ	ETF	291.7	292.41	290.61	290.98	2693140.0
2020-11-18 10:00:00	QQQ	ETF	290.96	291.87	290.53	291.6	1760395.0
2020-11-18 10:30:00	QQQ	ETF	291.61	292.2	291.17	292.1095	1294763.0
2020-11-18 11:00:00	QQQ	ETF	292.11	292.29	291.65	291.88	1078126.0
2020-11-18 11:30:00	QQQ	ETF	291.885	292.6415	291.7418	292.6415	860387.0
2020-11-18 12:00:00	QQQ	ETF	292.65	293.29	292.642	292.98	1185093.0
2020-11-18 12:30:00	QQQ	ETF	293.01	293.37	292.74	292.904	597732.0

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

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