PREVIEW / etf_30min / 2022-02-24

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-24.parquet
  size:    769 KB
  rows:    30,621

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-02-24 04:00:00	SPY	ETF	415.56	418.0	413.48	414.57	256722.0
2022-02-24 04:30:00	SPY	ETF	414.66	415.03	413.5	413.5	161218.0
2022-02-24 05:00:00	SPY	ETF	413.44	414.74	412.37	412.98	116426.0
2022-02-24 05:30:00	SPY	ETF	413.05	414.24	412.76	412.83	189871.0
2022-02-24 06:00:00	SPY	ETF	412.9	413.1	411.13	411.53	264193.0
2022-02-24 06:30:00	SPY	ETF	411.51	413.39	410.8	413.39	320840.0
2022-02-24 07:00:00	SPY	ETF	413.38	413.48	411.37	411.82	451450.0
2022-02-24 07:30:00	SPY	ETF	411.62	411.85	410.79	411.7	665625.0
2022-02-24 08:00:00	SPY	ETF	415.503	415.503	410.1	410.4	1046150.0
2022-02-24 08:30:00	SPY	ETF	410.41	421.95	410.27	411.489	1381255.0
2022-02-24 09:00:00	SPY	ETF	411.44	421.95	410.87	411.04	1079418.0
2022-02-24 09:30:00	SPY	ETF	411.02	415.93	410.64	415.72	20770313.0
2022-02-24 10:00:00	SPY	ETF	415.71	418.14	413.11	415.43	14672746.0
2022-02-24 10:30:00	SPY	ETF	415.45	417.97	414.42	417.07	10341266.0
2022-02-24 11:00:00	SPY	ETF	417.06	419.48	416.23	417.7272	8491579.0
2022-02-24 11:30:00	SPY	ETF	417.7	418.79	416.07	418.69	7679967.0
2022-02-24 12:00:00	SPY	ETF	418.67	418.7926	415.34	416.4699	6089694.0
2022-02-24 12:30:00	SPY	ETF	416.46	417.94	415.4	416.4273	5971377.0
2022-02-24 13:00:00	SPY	ETF	416.41	418.25	415.74	416.53	5019130.0
2022-02-24 13:30:00	SPY	ETF	416.54	421.4	416.44	418.98	9616717.0
2022-02-24 14:00:00	SPY	ETF	418.975	420.81	417.84	420.7014	9013557.0
2022-02-24 14:30:00	SPY	ETF	420.7	423.82	420.6	423.36	11745485.0
2022-02-24 15:00:00	SPY	ETF	423.37	425.05	422.95	423.76	9711528.0
2022-02-24 15:30:00	SPY	ETF	423.74	428.76	423.67	428.31	22099902.0
2022-02-24 16:00:00	SPY	ETF	428.3	428.42	426.08	426.41	5157788.0
2022-02-24 16:30:00	SPY	ETF	426.45	427.79	426.18	426.78	431441.0
2022-02-24 17:00:00	SPY	ETF	426.77	427.19	426.76	427.07	51153.0
2022-02-24 17:30:00	SPY	ETF	427.06	428.3	426.85	426.9	1177626.0
2022-02-24 18:00:00	SPY	ETF	426.81	428.3	425.61	425.88	171707.0
2022-02-24 18:30:00	SPY	ETF	428.3	428.3	425.2	425.94	72457.0
2022-02-24 19:00:00	SPY	ETF	425.91	427.61	425.91	427.25	80232.0
2022-02-24 19:30:00	SPY	ETF	427.25	427.43	425.71	425.91	149000.0
2022-02-24 04:00:00	QQQ	ETF	322.7	323.14	321.18	321.84	353397.0
2022-02-24 04:30:00	QQQ	ETF	321.97	322.31	320.55	320.91	116150.0
2022-02-24 05:00:00	QQQ	ETF	321.05	322.4	319.89	320.26	189144.0
2022-02-24 05:30:00	QQQ	ETF	320.2	321.39	320.05	320.54	131300.0
2022-02-24 06:00:00	QQQ	ETF	320.44	320.85	318.91	319.48	298539.0
2022-02-24 06:30:00	QQQ	ETF	319.53	320.96	318.82	320.86	232005.0
2022-02-24 07:00:00	QQQ	ETF	320.94	320.98	319.15	319.31	509904.0
2022-02-24 07:30:00	QQQ	ETF	319.31	319.38	318.39	319.03	520519.0
2022-02-24 08:00:00	QQQ	ETF	320.93	329.667	317.75	318.0	1246156.0
2022-02-24 08:30:00	QQQ	ETF	317.95	329.42	317.95	319.45	959428.0
2022-02-24 09:00:00	QQQ	ETF	319.53	320.74	318.72	318.87	986771.0
2022-02-24 09:30:00	QQQ	ETF	318.84	325.97	318.26	325.41	15503752.0
2022-02-24 10:00:00	QQQ	ETF	325.4	328.87	323.11	326.0399	10563009.0
2022-02-24 10:30:00	QQQ	ETF	326.04	329.1798	324.6	328.1353	7837006.0
2022-02-24 11:00:00	QQQ	ETF	328.12	330.8	327.3	329.12	6578149.0
2022-02-24 11:30:00	QQQ	ETF	329.15	330.5	327.6	330.29	5107561.0
2022-02-24 12:00:00	QQQ	ETF	330.31	330.599	326.93	328.03	4295971.0
2022-02-24 12:30:00	QQQ	ETF	328.01	329.94	327.16	328.18	3964672.0

> showing 50 of 30,621 rows — these rows as CSV

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