PREVIEW / etf_30min / 2020-11-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-09.parquet
  size:    638 KB
  rows:    24,543

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-09 04:00:00	SPY	ETF	355.0	355.83	354.73	354.8	50860.0
2020-11-09 04:30:00	SPY	ETF	354.95	355.14	354.65	355.01	15474.0
2020-11-09 05:00:00	SPY	ETF	355.11	355.27	354.71	355.1	27533.0
2020-11-09 05:30:00	SPY	ETF	355.23	355.6	355.18	355.56	14823.0
2020-11-09 06:00:00	SPY	ETF	355.5	355.54	355.21	355.24	36969.0
2020-11-09 06:30:00	SPY	ETF	355.16	365.32	355.04	363.66	1760125.0
2020-11-09 07:00:00	SPY	ETF	363.51	364.0	361.08	362.4	2173623.0
2020-11-09 07:30:00	SPY	ETF	362.46	364.66	361.89	364.66	2226503.0
2020-11-09 08:00:00	SPY	ETF	364.7	365.65	355.01	365.07	1947139.0
2020-11-09 08:30:00	SPY	ETF	365.07	366.77	364.87	365.23	2199482.0
2020-11-09 09:00:00	SPY	ETF	365.3	366.1	363.71	363.92	1283307.0
2020-11-09 09:30:00	SPY	ETF	363.97	364.38	360.39	360.54	29727546.0
2020-11-09 10:00:00	SPY	ETF	360.54	363.0	360.47	361.42	16523227.0
2020-11-09 10:30:00	SPY	ETF	361.415	362.12	359.0	360.35	11497872.0
2020-11-09 11:00:00	SPY	ETF	360.37	360.61	358.67	360.49	9042549.0
2020-11-09 11:30:00	SPY	ETF	360.485	360.63	359.045	359.6699	7166254.0
2020-11-09 12:00:00	SPY	ETF	359.68	361.26	359.41	361.04	8497606.0
2020-11-09 12:30:00	SPY	ETF	361.07	361.69	360.59	361.4801	7905254.0
2020-11-09 13:00:00	SPY	ETF	361.52	362.135	361.28	361.5	4768623.0
2020-11-09 13:30:00	SPY	ETF	361.51	361.78	360.7	361.15	5563223.0
2020-11-09 14:00:00	SPY	ETF	361.14	361.31	359.26	359.58	5838731.0
2020-11-09 14:30:00	SPY	ETF	359.58	360.03	358.89	359.65	6101725.0
2020-11-09 15:00:00	SPY	ETF	359.66	360.37	358.06	358.185	9274359.0
2020-11-09 15:30:00	SPY	ETF	358.195	359.26	354.06	354.54	22334588.0
2020-11-09 16:00:00	SPY	ETF	354.54	355.58	354.33	355.13	12974139.0
2020-11-09 16:30:00	SPY	ETF	355.13	355.13	354.11	354.57	1461098.0
2020-11-09 17:00:00	SPY	ETF	354.56	354.9	354.33	354.88	140216.0
2020-11-09 17:30:00	SPY	ETF	354.89	354.92	354.74	354.85	119811.0
2020-11-09 18:00:00	SPY	ETF	354.81	356.11	354.79	355.91	189027.0
2020-11-09 18:30:00	SPY	ETF	355.95	356.11	354.6	354.71	114987.0
2020-11-09 19:00:00	SPY	ETF	354.68	355.1	353.07	353.37	224121.0
2020-11-09 19:30:00	SPY	ETF	353.31	353.99	353.22	353.89	118220.0
2020-11-09 04:00:00	QQQ	ETF	300.46	300.73	297.0	299.24	78046.0
2020-11-09 04:30:00	QQQ	ETF	299.25	299.86	299.25	299.51	20459.0
2020-11-09 05:00:00	QQQ	ETF	299.68	299.99	299.49	299.7	22173.0
2020-11-09 05:30:00	QQQ	ETF	299.79	300.38	299.69	300.24	21935.0
2020-11-09 06:00:00	QQQ	ETF	300.3	300.3	299.59	299.76	47105.0
2020-11-09 06:30:00	QQQ	ETF	299.71	302.0	298.85	299.85	505202.0
2020-11-09 07:00:00	QQQ	ETF	299.82	299.97	295.77	296.21	2120050.0
2020-11-09 07:30:00	QQQ	ETF	296.21	296.45	283.0	295.44	2805664.0
2020-11-09 08:00:00	QQQ	ETF	295.47	302.5	291.02	296.101	1930594.0
2020-11-09 08:30:00	QQQ	ETF	296.0204	299.59	295.99	296.53	1702921.0
2020-11-09 09:00:00	QQQ	ETF	296.55	297.83	296.01	297.46	828879.0
2020-11-09 09:30:00	QQQ	ETF	297.31	297.84	293.74	295.44	10321725.0
2020-11-09 10:00:00	QQQ	ETF	295.44	299.03	295.33	298.3	6426730.0
2020-11-09 10:30:00	QQQ	ETF	298.33	299.03	295.32	296.64	4618682.0
2020-11-09 11:00:00	QQQ	ETF	296.636	299.14	294.545	297.24	4556595.0
2020-11-09 11:30:00	QQQ	ETF	297.23	297.26	295.3	295.49	3241997.0
2020-11-09 12:00:00	QQQ	ETF	295.51	296.07	294.33	295.54	3503125.0
2020-11-09 12:30:00	QQQ	ETF	295.6	295.96	294.59	295.62	2149705.0

> showing 50 of 24,543 rows — these rows as CSV

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