PREVIEW / etf_30min / 2022-07-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-14.parquet
  size:    668 KB
  rows:    26,641

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-07-14 04:00:00	SPY	ETF	376.44	376.82	375.65	375.9	48668.0
2022-07-14 04:30:00	SPY	ETF	375.6	375.73	374.16	374.6	137376.0
2022-07-14 05:00:00	SPY	ETF	374.48	374.9	374.21	374.62	29111.0
2022-07-14 05:30:00	SPY	ETF	374.52	375.4	374.29	375.24	67258.0
2022-07-14 06:00:00	SPY	ETF	375.38	375.5	374.88	374.93	62279.0
2022-07-14 06:30:00	SPY	ETF	375.07	375.32	373.62	374.09	269529.0
2022-07-14 07:00:00	SPY	ETF	374.07	374.63	373.84	374.19	288213.0
2022-07-14 07:30:00	SPY	ETF	374.25	374.6	373.68	373.79	288442.0
2022-07-14 08:00:00	SPY	ETF	374.4299	378.72	373.01	373.88	403228.0
2022-07-14 08:30:00	SPY	ETF	373.97	374.99	372.9	374.02	635972.0
2022-07-14 09:00:00	SPY	ETF	373.93	374.3	373.22	373.66	552426.0
2022-07-14 09:30:00	SPY	ETF	373.66	374.4	371.7416	372.33	8293789.0
2022-07-14 10:00:00	SPY	ETF	372.33	372.33	371.04	371.97	5628309.0
2022-07-14 10:30:00	SPY	ETF	371.98	373.04	371.36	372.36	3741929.0
2022-07-14 11:00:00	SPY	ETF	372.36	374.5	372.25	374.2	4370557.0
2022-07-14 11:30:00	SPY	ETF	374.19	375.99	373.43	375.6901	4571993.0
2022-07-14 12:00:00	SPY	ETF	375.7	375.95	374.14	374.21	2879408.0
2022-07-14 12:30:00	SPY	ETF	374.22	374.77	373.14	373.9401	2661494.0
2022-07-14 13:00:00	SPY	ETF	373.969	375.22	373.22	375.105	2772347.0
2022-07-14 13:30:00	SPY	ETF	375.11	375.82	374.38	375.6	2736991.0
2022-07-14 14:00:00	SPY	ETF	375.605	377.76	375.49	377.71	4560950.0
2022-07-14 14:30:00	SPY	ETF	377.695	378.36	377.11	377.78	3581158.0
2022-07-14 15:00:00	SPY	ETF	377.78	378.51	377.03	378.4907	3695501.0
2022-07-14 15:30:00	SPY	ETF	378.49	378.57	377.12	377.96	7326964.0
2022-07-14 16:00:00	SPY	ETF	377.96	378.4	377.9	378.01	2442949.0
2022-07-14 16:30:00	SPY	ETF	378.06	378.34	377.95	378.15	93463.0
2022-07-14 17:00:00	SPY	ETF	378.15	378.27	378.0	378.05	19115.0
2022-07-14 17:30:00	SPY	ETF	378.14	378.22	378.14	378.21	8673.0
2022-07-14 18:00:00	SPY	ETF	378.21	378.84	378.21	378.8	53469.0
2022-07-14 18:30:00	SPY	ETF	378.79	379.26	378.79	378.99	38526.0
2022-07-14 19:00:00	SPY	ETF	378.96	379.08	378.88	379.04	15042.0
2022-07-14 19:30:00	SPY	ETF	379.0	379.56	378.95	379.56	54475.0
2022-07-14 04:00:00	QQQ	ETF	283.67	284.25	283.25	283.44	98988.0
2022-07-14 04:30:00	QQQ	ETF	283.4	283.54	281.93	282.73	143653.0
2022-07-14 05:00:00	QQQ	ETF	282.62	283.14	282.35	282.87	129276.0
2022-07-14 05:30:00	QQQ	ETF	282.86	283.5	282.53	283.47	49418.0
2022-07-14 06:00:00	QQQ	ETF	283.47	283.65	283.16	283.36	44717.0
2022-07-14 06:30:00	QQQ	ETF	283.47	283.76	282.72	283.31	109840.0
2022-07-14 07:00:00	QQQ	ETF	283.28	283.66	282.79	283.16	198903.0
2022-07-14 07:30:00	QQQ	ETF	283.19	283.56	282.69	282.98	191808.0
2022-07-14 08:00:00	QQQ	ETF	283.2001	285.864	282.2196	282.93	347001.0
2022-07-14 08:30:00	QQQ	ETF	282.93	283.98	282.0	283.35	979998.0
2022-07-14 09:00:00	QQQ	ETF	283.29	283.75	282.61	283.03	662976.0
2022-07-14 09:30:00	QQQ	ETF	282.99	283.93	280.68	281.1383	6976174.0
2022-07-14 10:00:00	QQQ	ETF	281.1	281.1301	279.8	280.85	5034680.0
2022-07-14 10:30:00	QQQ	ETF	280.84	282.13	280.31	281.53	3461985.0
2022-07-14 11:00:00	QQQ	ETF	281.54	283.58	281.4701	283.21	3561020.0
2022-07-14 11:30:00	QQQ	ETF	283.1699	284.74	282.51	284.375	3444714.0
2022-07-14 12:00:00	QQQ	ETF	284.4094	284.7	283.16	283.24	2322809.0
2022-07-14 12:30:00	QQQ	ETF	283.23	283.67	282.42	283.16	2095100.0

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

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