PREVIEW / etf_30min / 2021-05-17

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-17.parquet
  size:    606 KB
  rows:    23,267

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-05-17 04:00:00	SPY	ETF	415.34	415.88	415.3	415.83	14655.0
2021-05-17 04:30:00	SPY	ETF	415.85	416.12	415.85	416.07	8699.0
2021-05-17 05:00:00	SPY	ETF	415.88	416.05	415.85	416.05	10537.0
2021-05-17 05:30:00	SPY	ETF	415.95	415.95	415.55	415.67	7691.0
2021-05-17 06:00:00	SPY	ETF	415.53	415.55	415.11	415.11	31424.0
2021-05-17 06:30:00	SPY	ETF	415.14	415.27	415.0	415.09	119021.0
2021-05-17 07:00:00	SPY	ETF	415.05	415.45	414.86	415.0	103360.0
2021-05-17 07:30:00	SPY	ETF	415.06	415.23	414.55	414.68	335394.0
2021-05-17 08:00:00	SPY	ETF	415.1099	416.5	414.45	414.82	283957.0
2021-05-17 08:30:00	SPY	ETF	414.8	415.13	414.68	414.95	204864.0
2021-05-17 09:00:00	SPY	ETF	414.9	415.46	414.81	415.38	208980.0
2021-05-17 09:30:00	SPY	ETF	415.39	416.39	414.48	414.94	7304525.0
2021-05-17 10:00:00	SPY	ETF	414.92	415.585	414.14	414.35	5201366.0
2021-05-17 10:30:00	SPY	ETF	414.34	415.41	413.94	414.89	4139384.0
2021-05-17 11:00:00	SPY	ETF	414.86	415.08	413.81	414.21	3750847.0
2021-05-17 11:30:00	SPY	ETF	414.23	414.79	413.87	414.16	3268544.0
2021-05-17 12:00:00	SPY	ETF	414.14	414.74	413.84	414.69	2525829.0
2021-05-17 12:30:00	SPY	ETF	414.68	415.12	414.35	414.47	1977209.0
2021-05-17 13:00:00	SPY	ETF	414.46	414.72	413.72	414.02	2088208.0
2021-05-17 13:30:00	SPY	ETF	414.01	414.34	413.36	414.025	2779398.0
2021-05-17 14:00:00	SPY	ETF	414.03	414.64	413.87	414.55	2041585.0
2021-05-17 14:30:00	SPY	ETF	414.5594	415.22	414.1501	415.17	2748969.0
2021-05-17 15:00:00	SPY	ETF	415.17	415.7	414.765	414.95	3797293.0
2021-05-17 15:30:00	SPY	ETF	414.96	415.63	414.77	415.54	8007877.0
2021-05-17 16:00:00	SPY	ETF	415.55	415.94	414.025	415.66	2023562.0
2021-05-17 16:30:00	SPY	ETF	415.66	415.8	415.52	415.75	403140.0
2021-05-17 17:00:00	SPY	ETF	415.77	415.84	415.77	415.77	20612.0
2021-05-17 17:30:00	SPY	ETF	415.77	415.8	415.64	415.64	11773.0
2021-05-17 18:00:00	SPY	ETF	415.64	415.87	415.64	415.76	98111.0
2021-05-17 18:30:00	SPY	ETF	415.52	415.76	415.35	415.35	100124.0
2021-05-17 19:00:00	SPY	ETF	415.37	415.75	415.37	415.75	61721.0
2021-05-17 19:30:00	SPY	ETF	415.74	416.23	415.69	416.23	35778.0
2021-05-17 04:00:00	QQQ	ETF	325.37	325.82	325.27	325.61	44970.0
2021-05-17 04:30:00	QQQ	ETF	325.68	325.91	325.55	325.8	10422.0
2021-05-17 05:00:00	QQQ	ETF	325.6	325.85	325.46	325.83	30843.0
2021-05-17 05:30:00	QQQ	ETF	325.84	325.93	325.31	325.31	22130.0
2021-05-17 06:00:00	QQQ	ETF	325.34	325.41	325.0	325.0	20155.0
2021-05-17 06:30:00	QQQ	ETF	325.02	325.23	324.95	325.2	206418.0
2021-05-17 07:00:00	QQQ	ETF	325.12	325.44	324.74	324.91	151959.0
2021-05-17 07:30:00	QQQ	ETF	325.0	325.19	324.51	324.55	131508.0
2021-05-17 08:00:00	QQQ	ETF	324.52	326.5	324.32	324.53	159058.0
2021-05-17 08:30:00	QQQ	ETF	324.55	324.9405	324.45	324.52	75434.0
2021-05-17 09:00:00	QQQ	ETF	324.5	324.93	324.44	324.62	300836.0
2021-05-17 09:30:00	QQQ	ETF	324.61	325.35	323.41	323.96	4962069.0
2021-05-17 10:00:00	QQQ	ETF	323.96	324.75	322.79	323.78	3917475.0
2021-05-17 10:30:00	QQQ	ETF	323.78	324.99	323.31	324.13	2347837.0
2021-05-17 11:00:00	QQQ	ETF	324.09	324.385	322.8	323.4	1770427.0
2021-05-17 11:30:00	QQQ	ETF	323.42	323.68	322.56	322.8	1594375.0
2021-05-17 12:00:00	QQQ	ETF	322.8	323.18	322.33	323.01	1212344.0
2021-05-17 12:30:00	QQQ	ETF	322.97	323.5198	322.6	322.7401	1193426.0

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

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