PREVIEW / etf_30min / 2020-11-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-30.parquet
  size:    611 KB
  rows:    22,728

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-30 04:00:00	SPY	ETF	362.18	362.44	362.02	362.1	18553.0
2020-11-30 04:30:00	SPY	ETF	362.1	362.3	361.92	362.25	5669.0
2020-11-30 05:00:00	SPY	ETF	362.29	362.29	362.04	362.04	15734.0
2020-11-30 05:30:00	SPY	ETF	362.22	362.39	362.06	362.34	17341.0
2020-11-30 06:00:00	SPY	ETF	362.2	362.42	362.2	362.27	3215.0
2020-11-30 06:30:00	SPY	ETF	362.02	362.12	361.43	362.03	27602.0
2020-11-30 07:00:00	SPY	ETF	362.12	362.92	362.05	362.82	120423.0
2020-11-30 07:30:00	SPY	ETF	362.8	363.21	362.68	362.738	194105.0
2020-11-30 08:00:00	SPY	ETF	362.7	363.2	360.85	362.57	190188.0
2020-11-30 08:30:00	SPY	ETF	362.59	362.83	362.43	362.83	128041.0
2020-11-30 09:00:00	SPY	ETF	362.81	363.46	362.71	362.79	253066.0
2020-11-30 09:30:00	SPY	ETF	362.83	363.12	361.89	362.27	3918163.0
2020-11-30 10:00:00	SPY	ETF	362.27	362.59	361.13	361.2	4138721.0
2020-11-30 10:30:00	SPY	ETF	361.21	361.24	359.17	360.9	6722029.0
2020-11-30 11:00:00	SPY	ETF	360.89	361.105	360.12	360.12	3541292.0
2020-11-30 11:30:00	SPY	ETF	360.11	360.6299	359.52	360.34	3392632.0
2020-11-30 12:00:00	SPY	ETF	360.33	361.0	360.0801	360.95	3015717.0
2020-11-30 12:30:00	SPY	ETF	360.95	361.37	360.75	361.308	2556603.0
2020-11-30 13:00:00	SPY	ETF	361.292	361.44	360.9148	361.18	2401023.0
2020-11-30 13:30:00	SPY	ETF	361.2	361.53	361.0	361.03	3188453.0
2020-11-30 14:00:00	SPY	ETF	361.0222	361.41	360.66	361.37	6461682.0
2020-11-30 14:30:00	SPY	ETF	361.37	362.15	361.07	362.15	3810922.0
2020-11-30 15:00:00	SPY	ETF	362.15	362.29	361.22	361.29	5808905.0
2020-11-30 15:30:00	SPY	ETF	361.28	362.4	361.13	362.0	17715039.0
2020-11-30 16:00:00	SPY	ETF	362.0	363.11	361.9264	362.66	9494486.0
2020-11-30 16:30:00	SPY	ETF	362.66	363.21	362.48	363.13	1363395.0
2020-11-30 17:00:00	SPY	ETF	363.17	363.17	362.85	362.85	907790.0
2020-11-30 17:30:00	SPY	ETF	362.85	362.86	362.61	362.8	192834.0
2020-11-30 18:00:00	SPY	ETF	362.8	363.09	362.52	362.57	264923.0
2020-11-30 18:30:00	SPY	ETF	362.55	363.86	362.51	363.76	161991.0
2020-11-30 19:00:00	SPY	ETF	363.81	364.0	363.71	363.9	81236.0
2020-11-30 19:30:00	SPY	ETF	363.9	364.4	363.81	364.33	100561.0
2020-11-30 04:00:00	QQQ	ETF	298.95	299.04	298.73	298.92	15420.0
2020-11-30 04:30:00	QQQ	ETF	298.83	298.98	298.53	298.92	31407.0
2020-11-30 05:00:00	QQQ	ETF	298.86	298.9	298.71	298.75	14092.0
2020-11-30 05:30:00	QQQ	ETF	298.9	299.18	298.87	299.07	13502.0
2020-11-30 06:00:00	QQQ	ETF	299.08	299.21	299.02	299.02	3958.0
2020-11-30 06:30:00	QQQ	ETF	298.93	299.06	298.58	298.94	16612.0
2020-11-30 07:00:00	QQQ	ETF	298.96	300.08	298.88	299.82	95516.0
2020-11-30 07:30:00	QQQ	ETF	299.77	300.02	299.62	299.68	60531.0
2020-11-30 08:00:00	QQQ	ETF	299.66	300.02	297.41	299.35	161100.0
2020-11-30 08:30:00	QQQ	ETF	299.35	299.5	299.06	299.39	75726.0
2020-11-30 09:00:00	QQQ	ETF	299.35	299.72	299.25	299.3	128770.0
2020-11-30 09:30:00	QQQ	ETF	299.3	299.97	298.14	298.85	2407503.0
2020-11-30 10:00:00	QQQ	ETF	298.86	299.145	297.6218	297.75	1515414.0
2020-11-30 10:30:00	QQQ	ETF	297.7	297.81	294.78	296.71	2926063.0
2020-11-30 11:00:00	QQQ	ETF	296.72	297.23	296.25	296.46	1482707.0
2020-11-30 11:30:00	QQQ	ETF	296.44	297.65	295.96	297.41	1249352.0
2020-11-30 12:00:00	QQQ	ETF	297.3788	297.879	297.05	297.84	849486.0
2020-11-30 12:30:00	QQQ	ETF	297.84	298.08	297.45	297.93	639916.0

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

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