PREVIEW / etf_30min / 2021-09-17

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-17.parquet
  size:    604 KB
  rows:    22,947

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
2021-09-17 04:00:00	SPY	ETF	447.02	447.02	445.74	445.74	12442.0
2021-09-17 04:30:00	SPY	ETF	445.74	445.8	445.7	445.78	1900.0
2021-09-17 05:00:00	SPY	ETF	445.78	445.78	445.09	445.25	10902.0
2021-09-17 05:30:00	SPY	ETF	445.15	445.15	444.55	444.77	22061.0
2021-09-17 06:00:00	SPY	ETF	444.64	444.95	444.25	444.44	11544.0
2021-09-17 06:30:00	SPY	ETF	444.47	444.63	444.2	444.62	18230.0
2021-09-17 07:00:00	SPY	ETF	444.64	444.86	444.42	444.55	115235.0
2021-09-17 07:30:00	SPY	ETF	444.52	444.84	444.41	444.7	64315.0
2021-09-17 08:00:00	SPY	ETF	444.8499	446.41	444.1896	445.46	212113.0
2021-09-17 08:30:00	SPY	ETF	445.47	445.62	445.22	445.45	150744.0
2021-09-17 09:00:00	SPY	ETF	445.41	445.77	444.89	444.9	473140.0
2021-09-17 09:30:00	SPY	ETF	444.92	445.37	443.09	443.505	7889201.0
2021-09-17 10:00:00	SPY	ETF	443.49	443.73	442.45	443.2	6781783.0
2021-09-17 10:30:00	SPY	ETF	443.21	443.21	441.94	442.43	5476293.0
2021-09-17 11:00:00	SPY	ETF	442.425	443.09	441.79	442.34	5398462.0
2021-09-17 11:30:00	SPY	ETF	442.335	442.55	441.63	442.25	5757616.0
2021-09-17 12:00:00	SPY	ETF	442.24	442.97	442.13	442.575	3532376.0
2021-09-17 12:30:00	SPY	ETF	442.58	443.24	442.55	442.69	3251168.0
2021-09-17 13:00:00	SPY	ETF	442.7	442.74	441.63	442.061	2963835.0
2021-09-17 13:30:00	SPY	ETF	442.0702	442.21	441.02	441.54	4823593.0
2021-09-17 14:00:00	SPY	ETF	441.53	442.06	441.25	441.37	3972822.0
2021-09-17 14:30:00	SPY	ETF	441.36	441.99	441.03	441.645	3725938.0
2021-09-17 15:00:00	SPY	ETF	441.635	442.14	441.28	441.4946	4303082.0
2021-09-17 15:30:00	SPY	ETF	441.485	442.22	441.11	441.42	14712849.0
2021-09-17 16:00:00	SPY	ETF	441.42	441.555	440.56	440.73	4770421.0
2021-09-17 16:30:00	SPY	ETF	440.7	440.72	440.07	440.22	584766.0
2021-09-17 17:00:00	SPY	ETF	440.2	440.39	440.19	440.39	190928.0
2021-09-17 17:30:00	SPY	ETF	440.39	441.4	440.21	440.37	1415560.0
2021-09-17 18:00:00	SPY	ETF	440.37	441.4	440.22	440.35	137457.0
2021-09-17 18:30:00	SPY	ETF	440.27	440.48	440.25	440.35	22127.0
2021-09-17 19:00:00	SPY	ETF	440.35	440.38	440.15	440.16	12215.0
2021-09-17 19:30:00	SPY	ETF	440.16	441.25	440.15	440.91	140432.0
2021-09-17 04:00:00	QQQ	ETF	378.02	378.33	378.02	378.29	29652.0
2021-09-17 04:30:00	QQQ	ETF	378.12	378.23	378.1	378.23	9297.0
2021-09-17 05:00:00	QQQ	ETF	378.27	378.27	377.69	377.82	20097.0
2021-09-17 05:30:00	QQQ	ETF	377.77	377.77	377.41	377.58	33551.0
2021-09-17 06:00:00	QQQ	ETF	377.47	377.82	377.3	377.45	30556.0
2021-09-17 06:30:00	QQQ	ETF	377.36	377.54	377.21	377.5	35294.0
2021-09-17 07:00:00	QQQ	ETF	377.5	377.59	377.18	377.32	62329.0
2021-09-17 07:30:00	QQQ	ETF	377.28	377.62	377.28	377.59	18266.0
2021-09-17 08:00:00	QQQ	ETF	377.4701	378.73	377.23	378.3	90583.0
2021-09-17 08:30:00	QQQ	ETF	378.27	378.48	378.09	378.23	83800.0
2021-09-17 09:00:00	QQQ	ETF	378.23	378.35	377.76	377.84	318505.0
2021-09-17 09:30:00	QQQ	ETF	377.82	377.87	375.38	375.85	6069176.0
2021-09-17 10:00:00	QQQ	ETF	375.81	375.919	374.85	375.44	3433527.0
2021-09-17 10:30:00	QQQ	ETF	375.45	375.45	374.18	374.52	2931894.0
2021-09-17 11:00:00	QQQ	ETF	374.52	374.86	373.63	374.0982	3036888.0
2021-09-17 11:30:00	QQQ	ETF	374.07	374.1	373.1	373.6	2802539.0
2021-09-17 12:00:00	QQQ	ETF	373.59	374.69	373.59	374.38	2147222.0
2021-09-17 12:30:00	QQQ	ETF	374.38	374.88	374.36	374.47	1397718.0

> showing 50 of 22,947 rows — these rows as CSV

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