PREVIEW / etf_30min / 2022-04-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-27.parquet
  size:    686 KB
  rows:    27,485

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-04-27 04:00:00	SPY	ETF	419.0	421.0	419.0	420.3	128009.0
2022-04-27 04:30:00	SPY	ETF	420.31	420.52	419.26	419.8	121214.0
2022-04-27 05:00:00	SPY	ETF	419.77	420.38	419.62	420.14	82774.0
2022-04-27 05:30:00	SPY	ETF	420.1	420.49	419.62	420.41	63004.0
2022-04-27 06:00:00	SPY	ETF	420.46	420.75	420.31	420.39	138750.0
2022-04-27 06:30:00	SPY	ETF	420.33	420.76	419.4	420.46	81310.0
2022-04-27 07:00:00	SPY	ETF	420.49	420.49	417.65	417.71	203349.0
2022-04-27 07:30:00	SPY	ETF	417.66	418.62	417.45	417.89	206245.0
2022-04-27 08:00:00	SPY	ETF	419.6999	420.75	416.1	418.07	294312.0
2022-04-27 08:30:00	SPY	ETF	418.05	418.46	417.44	417.82	280432.0
2022-04-27 09:00:00	SPY	ETF	418.0	418.25	416.78	417.24	482501.0
2022-04-27 09:30:00	SPY	ETF	417.24	422.02	417.15	420.75	11542434.0
2022-04-27 10:00:00	SPY	ETF	420.75	421.77	415.81	415.94	9333902.0
2022-04-27 10:30:00	SPY	ETF	415.93	419.32	415.01	418.0262	7484035.0
2022-04-27 11:00:00	SPY	ETF	418.04	420.0299	417.71	419.8	6248675.0
2022-04-27 11:30:00	SPY	ETF	419.82	421.0	418.935	419.69	4891447.0
2022-04-27 12:00:00	SPY	ETF	419.68	422.24	418.73	422.11	4340459.0
2022-04-27 12:30:00	SPY	ETF	422.13	422.92	421.34	422.055	4581921.0
2022-04-27 13:00:00	SPY	ETF	422.06	422.35	419.65	421.53	6825873.0
2022-04-27 13:30:00	SPY	ETF	421.53	422.15	420.44	421.93	3071219.0
2022-04-27 14:00:00	SPY	ETF	421.9242	421.96	420.21	420.37	2476943.0
2022-04-27 14:30:00	SPY	ETF	420.37	421.56	418.29	418.71	4551503.0
2022-04-27 15:00:00	SPY	ETF	418.71	419.0	417.24	418.27	6080230.0
2022-04-27 15:30:00	SPY	ETF	418.26	418.79	416.53	417.26	14512155.0
2022-04-27 16:00:00	SPY	ETF	417.25	419.3	416.84	419.06	3789613.0
2022-04-27 16:30:00	SPY	ETF	419.07	420.87	419.04	420.44	863402.0
2022-04-27 17:00:00	SPY	ETF	420.46	420.46	420.08	420.2201	173649.0
2022-04-27 17:30:00	SPY	ETF	420.22	420.57	420.18	420.5	84794.0
2022-04-27 18:00:00	SPY	ETF	420.6	420.99	420.21	420.21	165533.0
2022-04-27 18:30:00	SPY	ETF	420.28	420.57	420.28	420.38	45665.0
2022-04-27 19:00:00	SPY	ETF	420.35	420.63	420.07	420.63	32613.0
2022-04-27 19:30:00	SPY	ETF	420.53	420.85	420.34	420.57	70037.0
2022-04-27 04:00:00	QQQ	ETF	318.76	321.05	318.76	320.4	308964.0
2022-04-27 04:30:00	QQQ	ETF	320.5	320.58	319.33	319.8	144457.0
2022-04-27 05:00:00	QQQ	ETF	319.66	320.37	319.53	320.14	59328.0
2022-04-27 05:30:00	QQQ	ETF	319.97	320.27	319.48	320.14	67218.0
2022-04-27 06:00:00	QQQ	ETF	320.23	320.52	319.88	319.99	40154.0
2022-04-27 06:30:00	QQQ	ETF	319.92	320.56	319.5	320.2	144615.0
2022-04-27 07:00:00	QQQ	ETF	320.18	320.25	317.12	317.15	360180.0
2022-04-27 07:30:00	QQQ	ETF	317.11	318.23	317.07	317.58	357310.0
2022-04-27 08:00:00	QQQ	ETF	318.13	320.53	317.11	317.71	581449.0
2022-04-27 08:30:00	QQQ	ETF	317.7	318.2	317.14	317.67	405428.0
2022-04-27 09:00:00	QQQ	ETF	317.72	317.98	316.52	317.23	697726.0
2022-04-27 09:30:00	QQQ	ETF	317.24	322.88	316.94	320.94	10888006.0
2022-04-27 10:00:00	QQQ	ETF	320.93	322.06	315.35	315.7681	11982219.0
2022-04-27 10:30:00	QQQ	ETF	315.76	319.6	315.0	317.84	8228179.0
2022-04-27 11:00:00	QQQ	ETF	317.84	320.19	317.8	319.29	6534791.0
2022-04-27 11:30:00	QQQ	ETF	319.32	320.7	318.09	318.7579	3659810.0
2022-04-27 12:00:00	QQQ	ETF	318.79	321.98	317.64	321.7973	3744343.0
2022-04-27 12:30:00	QQQ	ETF	321.85	322.29	320.71	321.28	3782273.0

> showing 50 of 27,485 rows — these rows as CSV

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