PREVIEW / etf_30min / 2022-04-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-18.parquet
  size:    680 KB
  rows:    27,028

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-18 04:00:00	SPY	ETF	436.18	436.51	435.83	436.4	18669.0
2022-04-18 04:30:00	SPY	ETF	436.39	436.39	436.18	436.18	7177.0
2022-04-18 05:00:00	SPY	ETF	436.11	436.12	435.32	435.57	10476.0
2022-04-18 05:30:00	SPY	ETF	435.55	435.67	435.55	435.67	4382.0
2022-04-18 06:00:00	SPY	ETF	435.64	436.27	435.64	436.15	10300.0
2022-04-18 06:30:00	SPY	ETF	436.16	436.21	436.05	436.15	16490.0
2022-04-18 07:00:00	SPY	ETF	436.05	437.36	436.05	437.08	100601.0
2022-04-18 07:30:00	SPY	ETF	437.13	437.15	436.53	436.64	44058.0
2022-04-18 08:00:00	SPY	ETF	436.33	437.35	435.57	436.73	159424.0
2022-04-18 08:30:00	SPY	ETF	436.75	437.1	436.55	436.57	180663.0
2022-04-18 09:00:00	SPY	ETF	436.55	437.31	436.43	436.81	181360.0
2022-04-18 09:30:00	SPY	ETF	436.81	439.46	436.73	437.76	6300875.0
2022-04-18 10:00:00	SPY	ETF	437.76	439.5	437.085	438.76	4161510.0
2022-04-18 10:30:00	SPY	ETF	438.75	439.5	438.135	438.57	2223327.0
2022-04-18 11:00:00	SPY	ETF	438.58	438.97	437.025	437.32	2254668.0
2022-04-18 11:30:00	SPY	ETF	437.33	437.41	436.21	437.16	2655359.0
2022-04-18 12:00:00	SPY	ETF	437.17	437.22	435.79	435.92	2219227.0
2022-04-18 12:30:00	SPY	ETF	435.92	436.7607	435.61	436.56	1735959.0
2022-04-18 13:00:00	SPY	ETF	436.55	437.56	436.385	437.29	1985958.0
2022-04-18 13:30:00	SPY	ETF	437.27	439.74	437.2	439.15	3901038.0
2022-04-18 14:00:00	SPY	ETF	439.14	439.75	438.28	438.95	3000648.0
2022-04-18 14:30:00	SPY	ETF	438.935	439.54	438.33	438.37	2484911.0
2022-04-18 15:00:00	SPY	ETF	438.38	438.56	437.03	437.07	2988651.0
2022-04-18 15:30:00	SPY	ETF	437.075	438.01	435.63	437.99	9097398.0
2022-04-18 16:00:00	SPY	ETF	437.99	439.53	437.8357	439.22	4572428.0
2022-04-18 16:30:00	SPY	ETF	439.2	439.28	437.97	439.03	185734.0
2022-04-18 17:00:00	SPY	ETF	439.02	439.19	439.0	439.08	101919.0
2022-04-18 17:30:00	SPY	ETF	439.05	439.25	439.04	439.15	26162.0
2022-04-18 18:00:00	SPY	ETF	439.14	439.27	437.97	439.24	133296.0
2022-04-18 18:30:00	SPY	ETF	439.26	439.52	439.21	439.21	21112.0
2022-04-18 19:00:00	SPY	ETF	439.21	439.4	439.11	439.11	10429.0
2022-04-18 19:30:00	SPY	ETF	439.1	440.21	439.01	440.12	72105.0
2022-04-18 04:00:00	QQQ	ETF	336.36	337.01	335.87	336.81	51865.0
2022-04-18 04:30:00	QQQ	ETF	336.88	336.92	336.5	336.5	10334.0
2022-04-18 05:00:00	QQQ	ETF	336.49	336.49	335.68	335.86	94127.0
2022-04-18 05:30:00	QQQ	ETF	335.93	336.09	335.93	335.98	19445.0
2022-04-18 06:00:00	QQQ	ETF	336.1	336.7	336.07	336.7	31843.0
2022-04-18 06:30:00	QQQ	ETF	336.68	336.68	336.48	336.56	35903.0
2022-04-18 07:00:00	QQQ	ETF	336.54	337.79	336.54	337.47	147645.0
2022-04-18 07:30:00	QQQ	ETF	337.47	337.57	336.96	337.05	98360.0
2022-04-18 08:00:00	QQQ	ETF	336.71	337.78	335.3	336.9199	273243.0
2022-04-18 08:30:00	QQQ	ETF	336.93	337.55	336.78	337.24	202196.0
2022-04-18 09:00:00	QQQ	ETF	337.23	337.73	337.06	337.34	257347.0
2022-04-18 09:30:00	QQQ	ETF	337.35	339.35	336.8	337.7605	7621286.0
2022-04-18 10:00:00	QQQ	ETF	337.74	341.04	337.01	340.51	4748692.0
2022-04-18 10:30:00	QQQ	ETF	340.49	340.9	339.065	339.53	2121278.0
2022-04-18 11:00:00	QQQ	ETF	339.53	340.0973	337.7	337.97	2331039.0
2022-04-18 11:30:00	QQQ	ETF	337.96	338.11	337.04	337.93	2282540.0
2022-04-18 12:00:00	QQQ	ETF	337.9412	338.0	335.855	335.94	2662390.0
2022-04-18 12:30:00	QQQ	ETF	335.93	336.7801	335.791	336.55	2150146.0

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

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