PREVIEW / etf_30min / 2022-04-26

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-26.parquet
  size:    692 KB
  rows:    27,758

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-26 04:00:00	SPY	ETF	426.65	428.39	426.43	427.63	29183.0
2022-04-26 04:30:00	SPY	ETF	427.55	427.88	427.18	427.88	8069.0
2022-04-26 05:00:00	SPY	ETF	427.88	428.0	427.42	427.45	9281.0
2022-04-26 05:30:00	SPY	ETF	427.4	427.78	427.12	427.5	12249.0
2022-04-26 06:00:00	SPY	ETF	427.65	427.88	427.03	427.15	28576.0
2022-04-26 06:30:00	SPY	ETF	427.11	427.41	426.92	426.92	11826.0
2022-04-26 07:00:00	SPY	ETF	426.95	427.15	426.45	427.15	65038.0
2022-04-26 07:30:00	SPY	ETF	427.13	427.13	426.371	427.13	119966.0
2022-04-26 08:00:00	SPY	ETF	426.58	429.25	426.33	426.95	147627.0
2022-04-26 08:30:00	SPY	ETF	427.09	427.12	425.92	426.6	313114.0
2022-04-26 09:00:00	SPY	ETF	426.56	426.56	425.52	425.79	322927.0
2022-04-26 09:30:00	SPY	ETF	425.82	426.04	423.43	423.86	8251448.0
2022-04-26 10:00:00	SPY	ETF	423.85	424.64	421.43	422.4633	6308718.0
2022-04-26 10:30:00	SPY	ETF	422.48	422.58	420.49	421.07	5178496.0
2022-04-26 11:00:00	SPY	ETF	421.04	421.55	420.17	420.8416	4280277.0
2022-04-26 11:30:00	SPY	ETF	420.83	421.24	419.41	419.445	4346941.0
2022-04-26 12:00:00	SPY	ETF	419.46	422.27	419.44	421.99	4157430.0
2022-04-26 12:30:00	SPY	ETF	421.99	422.31	420.57	422.225	3130123.0
2022-04-26 13:00:00	SPY	ETF	422.2144	422.26	419.0	419.19	3722318.0
2022-04-26 13:30:00	SPY	ETF	419.12	420.57	418.74	419.41	4545438.0
2022-04-26 14:00:00	SPY	ETF	419.41	420.95	419.0	420.58	3925954.0
2022-04-26 14:30:00	SPY	ETF	420.54	421.0	419.23	420.75	4010204.0
2022-04-26 15:00:00	SPY	ETF	420.72	421.22	417.61	417.96	6517919.0
2022-04-26 15:30:00	SPY	ETF	417.95	418.45	416.07	416.11	16583215.0
2022-04-26 16:00:00	SPY	ETF	416.12	416.99	413.89	414.32	5976839.0
2022-04-26 16:30:00	SPY	ETF	414.31	414.31	413.0	413.25	507781.0
2022-04-26 17:00:00	SPY	ETF	413.41	414.0	413.35	414.0	99481.0
2022-04-26 17:30:00	SPY	ETF	414.07	414.5	414.01	414.4596	124352.0
2022-04-26 18:00:00	SPY	ETF	414.55	416.9	414.3	416.81	415045.0
2022-04-26 18:30:00	SPY	ETF	416.87	417.01	415.64	415.92	220197.0
2022-04-26 19:00:00	SPY	ETF	415.93	416.43	415.88	416.15	24836.0
2022-04-26 19:30:00	SPY	ETF	416.18	416.97	416.18	416.6	73510.0
2022-04-26 20:00:00	SPY	ETF	416.6	416.6	416.6	416.6	150.0
2022-04-26 04:00:00	QQQ	ETF	327.83	329.17	327.65	329.04	52286.0
2022-04-26 04:30:00	QQQ	ETF	328.99	329.4	328.68	329.38	13253.0
2022-04-26 05:00:00	QQQ	ETF	329.31	329.56	328.97	329.08	21201.0
2022-04-26 05:30:00	QQQ	ETF	329.02	329.43	328.7	329.09	10562.0
2022-04-26 06:00:00	QQQ	ETF	328.98	329.24	328.31	328.51	14629.0
2022-04-26 06:30:00	QQQ	ETF	328.46	328.89	328.31	328.35	22431.0
2022-04-26 07:00:00	QQQ	ETF	328.37	328.66	327.9	328.64	178582.0
2022-04-26 07:30:00	QQQ	ETF	328.62	328.62	327.9	328.58	156813.0
2022-04-26 08:00:00	QQQ	ETF	328.6	329.827	327.7	328.5	157436.0
2022-04-26 08:30:00	QQQ	ETF	328.5999	328.72	327.62	328.32	248979.0
2022-04-26 09:00:00	QQQ	ETF	328.28	328.28	327.15	327.45	399587.0
2022-04-26 09:30:00	QQQ	ETF	327.47	327.66	322.88	323.25	8629238.0
2022-04-26 10:00:00	QQQ	ETF	323.21	323.4	320.82	321.869	7542616.0
2022-04-26 10:30:00	QQQ	ETF	321.89	322.0901	320.07	320.26	6939863.0
2022-04-26 11:00:00	QQQ	ETF	320.25	320.8	319.25	320.215	5516937.0
2022-04-26 11:30:00	QQQ	ETF	320.2	320.87	319.05	319.1824	4375918.0
2022-04-26 12:00:00	QQQ	ETF	319.19	322.0	319.185	321.7355	4692968.0

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

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