PREVIEW / etf_30min / 2021-10-25

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-25.parquet
  size:    634 KB
  rows:    24,073

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-10-25 04:00:00	SPY	ETF	453.04	454.1	453.04	453.78	6729.0
2021-10-25 04:30:00	SPY	ETF	453.71	453.85	453.68	453.68	2600.0
2021-10-25 05:00:00	SPY	ETF	453.61	453.8	453.43	453.45	5829.0
2021-10-25 05:30:00	SPY	ETF	453.48	453.63	453.48	453.49	19183.0
2021-10-25 06:00:00	SPY	ETF	453.49	453.78	453.49	453.76	5399.0
2021-10-25 06:30:00	SPY	ETF	453.79	453.84	453.72	453.75	10524.0
2021-10-25 07:00:00	SPY	ETF	453.7	453.8	453.35	453.65	29427.0
2021-10-25 07:30:00	SPY	ETF	453.65	453.9	453.57	453.86	71471.0
2021-10-25 08:00:00	SPY	ETF	453.5496	454.01	453.4	453.86	95825.0
2021-10-25 08:30:00	SPY	ETF	453.87	453.95	453.75	453.76	66133.0
2021-10-25 09:00:00	SPY	ETF	453.79	454.34	453.78	454.25	231557.0
2021-10-25 09:30:00	SPY	ETF	454.28	454.3	452.39	453.67	4526303.0
2021-10-25 10:00:00	SPY	ETF	453.68	454.02	453.29	453.92	2532474.0
2021-10-25 10:30:00	SPY	ETF	453.92	454.28	453.705	454.18	2171545.0
2021-10-25 11:00:00	SPY	ETF	454.17	454.69	454.01	454.62	2205630.0
2021-10-25 11:30:00	SPY	ETF	454.64	454.91	454.36	454.89	1531949.0
2021-10-25 12:00:00	SPY	ETF	454.895	455.45	454.745	455.34	1794261.0
2021-10-25 12:30:00	SPY	ETF	455.34	455.57	455.1701	455.38	1053140.0
2021-10-25 13:00:00	SPY	ETF	455.38	455.9	455.38	455.63	1481176.0
2021-10-25 13:30:00	SPY	ETF	455.62	455.71	455.255	455.43	1145096.0
2021-10-25 14:00:00	SPY	ETF	455.4	455.78	455.2	455.77	1404914.0
2021-10-25 14:30:00	SPY	ETF	455.76	455.89	455.37	455.51	1692241.0
2021-10-25 15:00:00	SPY	ETF	455.52	455.59	455.1	455.44	2022151.0
2021-10-25 15:30:00	SPY	ETF	455.43	455.51	454.88	455.49	7166574.0
2021-10-25 16:00:00	SPY	ETF	455.49	455.89	454.77	455.87	2670003.0
2021-10-25 16:30:00	SPY	ETF	455.89	456.09	455.2908	456.0	330470.0
2021-10-25 17:00:00	SPY	ETF	456.01	456.03	455.55	455.96	47095.0
2021-10-25 17:30:00	SPY	ETF	455.97	456.05	455.88	455.96	19330.0
2021-10-25 18:00:00	SPY	ETF	455.97	456.01	455.81	455.98	24736.0
2021-10-25 18:30:00	SPY	ETF	455.9	455.9	455.69	455.7	14453.0
2021-10-25 19:00:00	SPY	ETF	455.73	455.85	455.69	455.77	17502.0
2021-10-25 19:30:00	SPY	ETF	455.79	456.2	455.79	456.16	27010.0
2021-10-25 04:00:00	QQQ	ETF	374.66	375.2	374.66	374.87	26018.0
2021-10-25 04:30:00	QQQ	ETF	374.77	374.9	374.72	374.84	15368.0
2021-10-25 05:00:00	QQQ	ETF	374.75	374.96	374.75	374.79	7475.0
2021-10-25 05:30:00	QQQ	ETF	374.7	374.87	374.7	374.83	7752.0
2021-10-25 06:00:00	QQQ	ETF	374.84	375.02	374.78	375.02	9590.0
2021-10-25 06:30:00	QQQ	ETF	374.99	375.05	374.94	374.95	18166.0
2021-10-25 07:00:00	QQQ	ETF	374.96	375.02	374.4	374.92	105257.0
2021-10-25 07:30:00	QQQ	ETF	374.85	375.27	374.85	375.21	61283.0
2021-10-25 08:00:00	QQQ	ETF	374.74	375.3	374.35	374.92	144752.0
2021-10-25 08:30:00	QQQ	ETF	374.96	375.35	374.85	375.02	125077.0
2021-10-25 09:00:00	QQQ	ETF	375.0	375.6	374.98	375.6	139148.0
2021-10-25 09:30:00	QQQ	ETF	375.57	376.24	373.56	375.2	4416645.0
2021-10-25 10:00:00	QQQ	ETF	375.22	375.82	374.89	375.8	1992758.0
2021-10-25 10:30:00	QQQ	ETF	375.7482	375.91	375.32	375.66	1080191.0
2021-10-25 11:00:00	QQQ	ETF	375.65	376.2	375.28	376.11	1311829.0
2021-10-25 11:30:00	QQQ	ETF	376.12	376.42	375.7	376.31	973451.0
2021-10-25 12:00:00	QQQ	ETF	376.33	377.255	376.28	377.16	1605063.0
2021-10-25 12:30:00	QQQ	ETF	377.18	377.99	377.16	377.7793	1576892.0

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

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