PREVIEW / etf_30min / 2022-04-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-13.parquet
  size:    670 KB
  rows:    25,951

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-13 04:00:00	SPY	ETF	440.05	441.48	440.05	440.85	11907.0
2022-04-13 04:30:00	SPY	ETF	440.76	441.62	440.76	441.38	5189.0
2022-04-13 05:00:00	SPY	ETF	441.37	441.44	440.97	440.97	6232.0
2022-04-13 05:30:00	SPY	ETF	440.88	440.94	439.57	439.57	13521.0
2022-04-13 06:00:00	SPY	ETF	439.56	440.06	439.56	439.87	7392.0
2022-04-13 06:30:00	SPY	ETF	440.03	440.87	440.03	440.8	82181.0
2022-04-13 07:00:00	SPY	ETF	440.82	441.26	440.67	440.9	91385.0
2022-04-13 07:30:00	SPY	ETF	440.84	440.84	438.83	439.07	282463.0
2022-04-13 08:00:00	SPY	ETF	439.03	441.7	438.02	438.35	357429.0
2022-04-13 08:30:00	SPY	ETF	438.42	438.9	437.82	437.92	580905.0
2022-04-13 09:00:00	SPY	ETF	437.94	438.58	437.5	438.0	552180.0
2022-04-13 09:30:00	SPY	ETF	438.03	440.25	437.84	439.05	7353712.0
2022-04-13 10:00:00	SPY	ETF	439.04	439.92	438.26	439.28	4864662.0
2022-04-13 10:30:00	SPY	ETF	439.29	439.94	438.77	439.825	2899607.0
2022-04-13 11:00:00	SPY	ETF	439.82	441.75	439.78	441.52	3312663.0
2022-04-13 11:30:00	SPY	ETF	441.54	441.99	440.81	441.02	3243683.0
2022-04-13 12:00:00	SPY	ETF	441.03	442.08	440.76	441.57	2845684.0
2022-04-13 12:30:00	SPY	ETF	441.58	442.59	441.58	442.1	2527190.0
2022-04-13 13:00:00	SPY	ETF	442.1	442.84	441.94	442.37	2528032.0
2022-04-13 13:30:00	SPY	ETF	442.36	442.44	441.53	442.02	2373713.0
2022-04-13 14:00:00	SPY	ETF	442.03	442.53	441.75	442.1701	2396944.0
2022-04-13 14:30:00	SPY	ETF	442.175	443.0	442.05	442.8	1893195.0
2022-04-13 15:00:00	SPY	ETF	442.805	443.58	442.29	443.485	3734908.0
2022-04-13 15:30:00	SPY	ETF	443.49	444.11	443.02	443.36	9503941.0
2022-04-13 16:00:00	SPY	ETF	443.36	443.41	442.91	443.05	3673873.0
2022-04-13 16:30:00	SPY	ETF	443.05	443.31	442.99	442.99	278573.0
2022-04-13 17:00:00	SPY	ETF	443.0	443.31	442.98	443.1	73584.0
2022-04-13 17:30:00	SPY	ETF	443.12	443.14	443.08	443.1	31421.0
2022-04-13 18:00:00	SPY	ETF	443.08	443.1	442.96	442.99	83178.0
2022-04-13 18:30:00	SPY	ETF	443.02	443.36	443.02	443.34	22274.0
2022-04-13 19:00:00	SPY	ETF	443.39	443.41	443.03	443.03	29451.0
2022-04-13 19:30:00	SPY	ETF	443.03	443.1	442.98	443.02	37398.0
2022-04-13 04:00:00	QQQ	ETF	342.06	342.81	341.97	342.23	98469.0
2022-04-13 04:30:00	QQQ	ETF	342.01	342.88	342.01	342.6	52025.0
2022-04-13 05:00:00	QQQ	ETF	342.57	342.76	342.26	342.31	18601.0
2022-04-13 05:30:00	QQQ	ETF	342.28	342.29	340.85	340.98	64234.0
2022-04-13 06:00:00	QQQ	ETF	340.92	341.31	340.87	341.02	20524.0
2022-04-13 06:30:00	QQQ	ETF	341.02	342.15	341.02	342.07	54873.0
2022-04-13 07:00:00	QQQ	ETF	342.06	342.53	341.91	342.21	131210.0
2022-04-13 07:30:00	QQQ	ETF	342.19	342.25	340.39	340.51	237068.0
2022-04-13 08:00:00	QQQ	ETF	342.2269	343.22	339.76	340.17	357341.0
2022-04-13 08:30:00	QQQ	ETF	340.12	340.73	338.83	339.8	393130.0
2022-04-13 09:00:00	QQQ	ETF	339.77	340.43	339.36	339.74	288424.0
2022-04-13 09:30:00	QQQ	ETF	339.81	342.7	339.06	341.33	6884863.0
2022-04-13 10:00:00	QQQ	ETF	341.35	343.35	340.83	342.75	4309345.0
2022-04-13 10:30:00	QQQ	ETF	342.77	343.84	342.02	342.58	3043821.0
2022-04-13 11:00:00	QQQ	ETF	342.59	345.2	342.555	344.8	3320052.0
2022-04-13 11:30:00	QQQ	ETF	344.81	345.18	344.27	344.6801	2200412.0
2022-04-13 12:00:00	QQQ	ETF	344.67	345.49	344.06	344.957	2355522.0
2022-04-13 12:30:00	QQQ	ETF	345.0	345.86	344.88	345.5101	2178023.0

> showing 50 of 25,951 rows — these rows as CSV

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