PREVIEW / etf_30min / 2022-06-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-06.parquet
  size:    663 KB
  rows:    26,017

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
2022-06-06 04:00:00	SPY	ETF	414.35	415.33	412.8	415.2	49229.0
2022-06-06 04:30:00	SPY	ETF	415.3	415.45	414.92	415.33	13161.0
2022-06-06 05:00:00	SPY	ETF	415.37	415.37	414.72	414.72	14836.0
2022-06-06 05:30:00	SPY	ETF	414.82	414.82	414.26	414.42	14644.0
2022-06-06 06:00:00	SPY	ETF	414.57	414.92	414.56	414.88	14981.0
2022-06-06 06:30:00	SPY	ETF	414.92	415.04	414.82	414.95	34799.0
2022-06-06 07:00:00	SPY	ETF	414.97	415.01	414.63	414.95	79879.0
2022-06-06 07:30:00	SPY	ETF	415.01	415.09	414.27	415.08	73509.0
2022-06-06 08:00:00	SPY	ETF	415.07	415.3	412.2	414.81	183076.0
2022-06-06 08:30:00	SPY	ETF	414.8	415.65	414.79	415.01	337939.0
2022-06-06 09:00:00	SPY	ETF	415.02	415.39	414.61	414.77	158560.0
2022-06-06 09:30:00	SPY	ETF	414.78	415.495	413.66	415.17	4903069.0
2022-06-06 10:00:00	SPY	ETF	415.17	416.609	415.02	415.93	4043799.0
2022-06-06 10:30:00	SPY	ETF	415.92	416.5	415.53	416.08	2986004.0
2022-06-06 11:00:00	SPY	ETF	416.09	416.5	412.77	413.4	4243281.0
2022-06-06 11:30:00	SPY	ETF	413.4125	414.255	412.89	413.73	2361300.0
2022-06-06 12:00:00	SPY	ETF	413.73	413.79	411.165	411.32	2838081.0
2022-06-06 12:30:00	SPY	ETF	411.315	412.52	410.84	412.42	2422203.0
2022-06-06 13:00:00	SPY	ETF	412.39	412.4	411.32	411.94	2328761.0
2022-06-06 13:30:00	SPY	ETF	411.94	413.82	411.7855	413.78	3063484.0
2022-06-06 14:00:00	SPY	ETF	413.78	413.83	411.53	411.78	2468511.0
2022-06-06 14:30:00	SPY	ETF	411.72	412.27	410.84	411.83	3343326.0
2022-06-06 15:00:00	SPY	ETF	411.84	412.21	410.56	411.08	2853192.0
2022-06-06 15:30:00	SPY	ETF	411.06	412.4	410.5523	411.76	6225259.0
2022-06-06 16:00:00	SPY	ETF	411.75	411.86	411.48	411.65	1740268.0
2022-06-06 16:30:00	SPY	ETF	411.63	412.09	411.62	411.86	82129.0
2022-06-06 17:00:00	SPY	ETF	411.86	412.1	411.76	411.91	45631.0
2022-06-06 17:30:00	SPY	ETF	411.91	411.99	411.7	411.99	31374.0
2022-06-06 18:00:00	SPY	ETF	411.95	412.17	411.6	411.63	55207.0
2022-06-06 18:30:00	SPY	ETF	411.62	411.62	411.33	411.39	17404.0
2022-06-06 19:00:00	SPY	ETF	411.46	411.71	411.4	411.67	6012.0
2022-06-06 19:30:00	SPY	ETF	411.69	412.16	411.6	411.9	35056.0
2022-06-06 04:00:00	QQQ	ETF	309.97	310.72	307.12	310.64	91791.0
2022-06-06 04:30:00	QQQ	ETF	310.7	310.93	310.46	310.85	31682.0
2022-06-06 05:00:00	QQQ	ETF	310.84	310.84	310.21	310.29	34035.0
2022-06-06 05:30:00	QQQ	ETF	310.38	310.38	309.82	309.98	78187.0
2022-06-06 06:00:00	QQQ	ETF	309.97	310.49	309.97	310.37	39451.0
2022-06-06 06:30:00	QQQ	ETF	310.42	310.78	310.33	310.59	37592.0
2022-06-06 07:00:00	QQQ	ETF	310.59	310.68	310.18	310.52	224954.0
2022-06-06 07:30:00	QQQ	ETF	310.57	310.72	309.91	310.6	163840.0
2022-06-06 08:00:00	QQQ	ETF	310.28	311.03	306.429	310.58	321350.0
2022-06-06 08:30:00	QQQ	ETF	310.55	311.27	310.51	310.67	300190.0
2022-06-06 09:00:00	QQQ	ETF	310.68	311.0	310.4	310.7	255671.0
2022-06-06 09:30:00	QQQ	ETF	310.75	311.79	309.04	310.86	5870077.0
2022-06-06 10:00:00	QQQ	ETF	310.855	312.35	310.81	311.6324	3734710.0
2022-06-06 10:30:00	QQQ	ETF	311.63	312.25	311.22	311.61	2430990.0
2022-06-06 11:00:00	QQQ	ETF	311.62	311.9284	308.01	308.6881	3811897.0
2022-06-06 11:30:00	QQQ	ETF	308.69	309.35	307.93	308.8899	2119692.0
2022-06-06 12:00:00	QQQ	ETF	308.85	308.91	306.083	306.2492	2593232.0
2022-06-06 12:30:00	QQQ	ETF	306.2201	307.55	305.62	307.36	2013401.0

> showing 50 of 26,017 rows — these rows as CSV

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