PREVIEW / etf_30min / 2021-03-17

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-17.parquet
  size:    619 KB
  rows:    23,230

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
2021-03-17 04:00:00	SPY	ETF	395.96	396.16	395.6	395.6	7165.0
2021-03-17 04:30:00	SPY	ETF	395.83	395.92	395.83	395.92	1300.0
2021-03-17 05:00:00	SPY	ETF	395.79	395.99	395.7	395.99	3350.0
2021-03-17 05:30:00	SPY	ETF	395.95	395.95	395.64	395.64	5600.0
2021-03-17 06:00:00	SPY	ETF	395.76	395.8	395.7	395.72	7972.0
2021-03-17 06:30:00	SPY	ETF	395.75	396.01	395.64	395.65	11202.0
2021-03-17 07:00:00	SPY	ETF	395.58	395.64	394.92	395.04	110014.0
2021-03-17 07:30:00	SPY	ETF	395.02	395.02	394.36	394.56	128075.0
2021-03-17 08:00:00	SPY	ETF	395.1201	396.899	394.31	394.74	195215.0
2021-03-17 08:30:00	SPY	ETF	394.7	394.87	394.57	394.84	96929.0
2021-03-17 09:00:00	SPY	ETF	394.81	394.88	394.45	394.54	259580.0
2021-03-17 09:30:00	SPY	ETF	394.53	394.89	393.8	394.57	6572882.0
2021-03-17 10:00:00	SPY	ETF	394.58	394.98	393.85	394.75	4515403.0
2021-03-17 10:30:00	SPY	ETF	394.74	394.74	393.42	393.65	4304405.0
2021-03-17 11:00:00	SPY	ETF	393.64	394.31	393.3	394.21	2959409.0
2021-03-17 11:30:00	SPY	ETF	394.195	394.41	393.84	394.155	2370836.0
2021-03-17 12:00:00	SPY	ETF	394.15	394.69	393.93	394.54	2435808.0
2021-03-17 12:30:00	SPY	ETF	394.55	394.56	393.8	393.92	2006009.0
2021-03-17 13:00:00	SPY	ETF	393.92	394.37	393.77	394.24	1696634.0
2021-03-17 13:30:00	SPY	ETF	394.24	394.34	393.7	393.975	2184367.0
2021-03-17 14:00:00	SPY	ETF	394.0	396.86	393.975	395.29	10434805.0
2021-03-17 14:30:00	SPY	ETF	395.28	397.79	395.06	397.66	8166659.0
2021-03-17 15:00:00	SPY	ETF	397.66	398.12	396.81	397.115	6374181.0
2021-03-17 15:30:00	SPY	ETF	397.12	397.7495	396.41	397.22	9585561.0
2021-03-17 16:00:00	SPY	ETF	397.21	397.43	397.01	397.28	5335337.0
2021-03-17 16:30:00	SPY	ETF	397.27	397.28	396.8396	396.92	337438.0
2021-03-17 17:00:00	SPY	ETF	396.85	397.02	396.85	397.01	62088.0
2021-03-17 17:30:00	SPY	ETF	397.02	397.26	396.9	396.97	50712.0
2021-03-17 18:00:00	SPY	ETF	396.97	397.7	396.97	397.67	269748.0
2021-03-17 18:30:00	SPY	ETF	397.26	397.7	397.26	397.42	63461.0
2021-03-17 19:00:00	SPY	ETF	397.5	397.65	397.31	397.55	43472.0
2021-03-17 19:30:00	SPY	ETF	397.65	398.1	397.65	398.01	79389.0
2021-03-17 04:00:00	QQQ	ETF	320.19	320.42	319.91	320.04	16652.0
2021-03-17 04:30:00	QQQ	ETF	320.13	320.32	320.1	320.25	5664.0
2021-03-17 05:00:00	QQQ	ETF	320.2	320.34	320.05	320.27	11953.0
2021-03-17 05:30:00	QQQ	ETF	320.25	320.25	319.66	319.69	20310.0
2021-03-17 06:00:00	QQQ	ETF	319.72	319.84	319.54	319.84	12226.0
2021-03-17 06:30:00	QQQ	ETF	319.87	320.12	319.39	319.45	25705.0
2021-03-17 07:00:00	QQQ	ETF	319.47	319.47	318.16	318.22	132803.0
2021-03-17 07:30:00	QQQ	ETF	318.22	318.22	316.78	317.0	343168.0
2021-03-17 08:00:00	QQQ	ETF	316.97	320.58	316.52	317.12	362203.0
2021-03-17 08:30:00	QQQ	ETF	317.09	320.58	316.74	317.28	246922.0
2021-03-17 09:00:00	QQQ	ETF	317.31	317.58	317.03	317.44	211554.0
2021-03-17 09:30:00	QQQ	ETF	317.45	318.34	315.68	318.15	6580596.0
2021-03-17 10:00:00	QQQ	ETF	318.1572	319.05	317.44	318.47	3789734.0
2021-03-17 10:30:00	QQQ	ETF	318.45	319.07	317.06	317.57	3941901.0
2021-03-17 11:00:00	QQQ	ETF	317.56	317.84	316.62	317.43	2810253.0
2021-03-17 11:30:00	QQQ	ETF	317.44	317.45	316.0318	316.56	3203913.0
2021-03-17 12:00:00	QQQ	ETF	316.55	317.79	315.815	317.56	2915929.0
2021-03-17 12:30:00	QQQ	ETF	317.56	317.59	316.3	316.4	2284569.0

> showing 50 of 23,230 rows — these rows as CSV

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