PREVIEW / etf_30min / 2020-11-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-16.parquet
  size:    606 KB
  rows:    22,933

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-16 04:00:00	SPY	ETF	360.58	361.01	360.47	360.78	24263.0
2020-11-16 04:30:00	SPY	ETF	360.9	361.3	360.85	361.13	13017.0
2020-11-16 05:00:00	SPY	ETF	361.27	361.28	360.9	360.9	7183.0
2020-11-16 05:30:00	SPY	ETF	360.9	360.99	360.7	360.99	2822.0
2020-11-16 06:00:00	SPY	ETF	361.06	361.34	361.01	361.12	9679.0
2020-11-16 06:30:00	SPY	ETF	361.1	363.67	360.7	361.84	304385.0
2020-11-16 07:00:00	SPY	ETF	361.83	362.95	361.46	361.67	893275.0
2020-11-16 07:30:00	SPY	ETF	361.7	362.09	361.59	362.0	197297.0
2020-11-16 08:00:00	SPY	ETF	361.95	362.85	360.7	361.66	240403.0
2020-11-16 08:30:00	SPY	ETF	361.65	361.69	361.0	361.22	415154.0
2020-11-16 09:00:00	SPY	ETF	361.25	361.76	360.94	361.07	544698.0
2020-11-16 09:30:00	SPY	ETF	360.98	361.2398	359.59	360.4	8743772.0
2020-11-16 10:00:00	SPY	ETF	360.4	361.5	360.195	361.5	4235078.0
2020-11-16 10:30:00	SPY	ETF	361.51	361.93	361.33	361.93	3372312.0
2020-11-16 11:00:00	SPY	ETF	361.94	362.25	361.8177	361.98	3656131.0
2020-11-16 11:30:00	SPY	ETF	361.97	362.0	361.65	361.77	1642312.0
2020-11-16 12:00:00	SPY	ETF	361.775	361.98	361.07	361.2	2453502.0
2020-11-16 12:30:00	SPY	ETF	361.2	361.45	360.81	361.1	2210897.0
2020-11-16 13:00:00	SPY	ETF	361.1011	361.11	360.055	360.13	2457112.0
2020-11-16 13:30:00	SPY	ETF	360.14	360.74	359.6499	360.57	3688505.0
2020-11-16 14:00:00	SPY	ETF	360.58	361.04	360.22	361.02	2952194.0
2020-11-16 14:30:00	SPY	ETF	361.03	361.24	360.71	360.919	4045969.0
2020-11-16 15:00:00	SPY	ETF	360.93	361.28	360.24	360.865	4905929.0
2020-11-16 15:30:00	SPY	ETF	360.86	362.59	360.74	362.44	16050904.0
2020-11-16 16:00:00	SPY	ETF	362.47	362.9	357.9984	362.83	7446532.0
2020-11-16 16:30:00	SPY	ETF	362.81	362.97	361.0983	362.73	609096.0
2020-11-16 17:00:00	SPY	ETF	362.77	362.82	362.7	362.78	132654.0
2020-11-16 17:30:00	SPY	ETF	362.79	362.81	362.6	362.6	82251.0
2020-11-16 18:00:00	SPY	ETF	362.57	362.81	362.36	362.59	244495.0
2020-11-16 18:30:00	SPY	ETF	362.6	362.6	362.27	362.35	84141.0
2020-11-16 19:00:00	SPY	ETF	362.34	362.34	361.75	361.88	179063.0
2020-11-16 19:30:00	SPY	ETF	361.91	361.91	361.6	361.76	148182.0
2020-11-16 04:00:00	QQQ	ETF	292.5	292.82	292.45	292.6	19950.0
2020-11-16 04:30:00	QQQ	ETF	292.69	293.0	292.51	292.79	7569.0
2020-11-16 05:00:00	QQQ	ETF	292.75	292.75	292.43	292.68	12707.0
2020-11-16 05:30:00	QQQ	ETF	292.56	292.88	292.33	292.55	8471.0
2020-11-16 06:00:00	QQQ	ETF	292.51	292.88	292.51	292.7	17243.0
2020-11-16 06:30:00	QQQ	ETF	292.71	293.04	290.9	290.94	117503.0
2020-11-16 07:00:00	QQQ	ETF	291.0	291.56	289.18	290.29	356563.0
2020-11-16 07:30:00	QQQ	ETF	290.3	291.02	290.07	290.77	156988.0
2020-11-16 08:00:00	QQQ	ETF	291.2799	293.7	289.3	290.34	228712.0
2020-11-16 08:30:00	QQQ	ETF	290.26	290.34	289.9	290.32	499372.0
2020-11-16 09:00:00	QQQ	ETF	290.27	291.16	290.18	290.7	421867.0
2020-11-16 09:30:00	QQQ	ETF	290.67	292.45	289.99	291.88	4267673.0
2020-11-16 10:00:00	QQQ	ETF	291.88	292.86	291.565	292.61	2062783.0
2020-11-16 10:30:00	QQQ	ETF	292.67	293.08	292.08	293.08	1540695.0
2020-11-16 11:00:00	QQQ	ETF	293.085	293.51	292.55	292.59	1311050.0
2020-11-16 11:30:00	QQQ	ETF	292.5967	292.67	292.07	292.57	1000436.0
2020-11-16 12:00:00	QQQ	ETF	292.59	292.8582	291.79	292.12	961815.0
2020-11-16 12:30:00	QQQ	ETF	292.1	292.32	291.54	291.8482	1082980.0

> showing 50 of 22,933 rows — these rows as CSV

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