PREVIEW / etf_30min / 2022-04-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-12.parquet
  size:    679 KB
  rows:    26,879

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-12 04:00:00	SPY	ETF	438.59	438.93	438.08	438.86	39857.0
2022-04-12 04:30:00	SPY	ETF	438.97	440.0	438.86	439.7	25432.0
2022-04-12 05:00:00	SPY	ETF	439.64	439.92	439.32	439.73	18286.0
2022-04-12 05:30:00	SPY	ETF	439.77	440.2	439.75	439.96	21666.0
2022-04-12 06:00:00	SPY	ETF	439.98	440.28	439.69	439.69	24577.0
2022-04-12 06:30:00	SPY	ETF	440.03	440.52	440.02	440.44	64435.0
2022-04-12 07:00:00	SPY	ETF	440.1	440.26	439.66	440.05	38767.0
2022-04-12 07:30:00	SPY	ETF	440.18	440.57	440.1	440.53	94123.0
2022-04-12 08:00:00	SPY	ETF	440.44	441.06	437.5	440.58	273055.0
2022-04-12 08:30:00	SPY	ETF	440.89	445.33	440.89	444.79	2147478.0
2022-04-12 09:00:00	SPY	ETF	444.74	444.78	442.97	443.08	783026.0
2022-04-12 09:30:00	SPY	ETF	443.08	445.75	442.37	445.06	7917540.0
2022-04-12 10:00:00	SPY	ETF	445.07	445.3	443.57	443.63	5030010.0
2022-04-12 10:30:00	SPY	ETF	443.63	443.89	442.22	442.63	4198428.0
2022-04-12 11:00:00	SPY	ETF	442.62	444.23	442.2199	444.06	3685927.0
2022-04-12 11:30:00	SPY	ETF	444.07	444.5	443.38	443.68	2596410.0
2022-04-12 12:00:00	SPY	ETF	443.69	443.75	441.63	441.79	3178263.0
2022-04-12 12:30:00	SPY	ETF	441.75	442.38	441.23	442.02	3160393.0
2022-04-12 13:00:00	SPY	ETF	442.01	442.7	441.17	441.64	3174281.0
2022-04-12 13:30:00	SPY	ETF	441.65	441.94	439.39	439.6099	3939809.0
2022-04-12 14:00:00	SPY	ETF	439.58	440.34	438.42	438.49	4759900.0
2022-04-12 14:30:00	SPY	ETF	438.48	439.29	437.97	438.83	5385342.0
2022-04-12 15:00:00	SPY	ETF	438.81	439.03	436.6501	437.06	6858664.0
2022-04-12 15:30:00	SPY	ETF	437.0599	438.78	436.68	438.24	10568917.0
2022-04-12 16:00:00	SPY	ETF	438.25	438.84	437.87	438.66	2798097.0
2022-04-12 16:30:00	SPY	ETF	438.67	438.77	438.48	438.59	68495.0
2022-04-12 17:00:00	SPY	ETF	438.6499	438.7	438.59	438.7	11287.0
2022-04-12 17:30:00	SPY	ETF	438.72	438.72	438.29	438.71	55709.0
2022-04-12 18:00:00	SPY	ETF	438.71	438.99	438.4	438.5	49344.0
2022-04-12 18:30:00	SPY	ETF	438.52	439.09	438.52	439.07	41943.0
2022-04-12 19:00:00	SPY	ETF	439.14	439.34	439.14	439.3	72730.0
2022-04-12 19:30:00	SPY	ETF	439.26	439.7	439.15	439.7	58353.0
2022-04-12 04:00:00	QQQ	ETF	340.0	340.6	339.86	340.47	102522.0
2022-04-12 04:30:00	QQQ	ETF	340.44	341.44	340.36	341.17	62370.0
2022-04-12 05:00:00	QQQ	ETF	341.14	341.37	340.66	341.19	29943.0
2022-04-12 05:30:00	QQQ	ETF	341.18	342.0	341.18	341.71	42119.0
2022-04-12 06:00:00	QQQ	ETF	341.94	342.0	341.11	341.45	28665.0
2022-04-12 06:30:00	QQQ	ETF	341.39	341.87	341.31	341.35	54103.0
2022-04-12 07:00:00	QQQ	ETF	341.32	341.36	340.65	341.19	129117.0
2022-04-12 07:30:00	QQQ	ETF	341.17	341.76	341.02	341.76	134334.0
2022-04-12 08:00:00	QQQ	ETF	341.33	342.49	338.81	342.009	391061.0
2022-04-12 08:30:00	QQQ	ETF	342.01	347.83	342.01	347.28	2885799.0
2022-04-12 09:00:00	QQQ	ETF	347.28	347.45	345.65	345.73	1063796.0
2022-04-12 09:30:00	QQQ	ETF	345.76	347.33	343.685	347.25	8446670.0
2022-04-12 10:00:00	QQQ	ETF	347.26	347.69	345.47	345.56	4467277.0
2022-04-12 10:30:00	QQQ	ETF	345.56	345.72	343.0791	343.78	4564803.0
2022-04-12 11:00:00	QQQ	ETF	343.76	345.395	343.01	345.25	4265827.0
2022-04-12 11:30:00	QQQ	ETF	345.26	345.86	344.36	344.71	2783950.0
2022-04-12 12:00:00	QQQ	ETF	344.72	344.76	342.56	342.79	3231114.0
2022-04-12 12:30:00	QQQ	ETF	342.765	343.949	342.44	343.44	2680785.0

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

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