PREVIEW / etf_1hour / 2021-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-24.parquet
  size:    413 KB
  rows:    14,331

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-06-24 04:00:00	SPY	ETF	423.84	424.6	423.84	424.56	43632.0
2021-06-24 05:00:00	SPY	ETF	424.58	424.87	424.58	424.67	19948.0
2021-06-24 06:00:00	SPY	ETF	424.61	424.83	424.61	424.61	21171.0
2021-06-24 07:00:00	SPY	ETF	424.62	424.79	424.5	424.66	124134.0
2021-06-24 08:00:00	SPY	ETF	424.63	424.83	423.75	424.52	246498.0
2021-06-24 09:00:00	SPY	ETF	424.55	425.29	424.48	424.92	4271522.0
2021-06-24 10:00:00	SPY	ETF	424.93	425.53	424.73	425.0	4885214.0
2021-06-24 11:00:00	SPY	ETF	425.01	425.19	424.62	424.775	2835910.0
2021-06-24 12:00:00	SPY	ETF	424.7819	425.335	424.76	425.19	3285019.0
2021-06-24 13:00:00	SPY	ETF	425.2	425.53	424.77	425.13	3403492.0
2021-06-24 14:00:00	SPY	ETF	425.13	425.55	425.11	425.395	3085504.0
2021-06-24 15:00:00	SPY	ETF	425.39	425.42	424.85	425.0899	9517234.0
2021-06-24 16:00:00	SPY	ETF	425.08	425.75	425.01	425.63	2233827.0
2021-06-24 17:00:00	SPY	ETF	425.66	425.72	425.07	425.68	774060.0
2021-06-24 18:00:00	SPY	ETF	425.68	425.68	425.1	425.57	48965.0
2021-06-24 19:00:00	SPY	ETF	425.61	425.63	425.38	425.4	36953.0
2021-06-24 04:00:00	QQQ	ETF	348.3	349.72	348.3	349.7	47549.0
2021-06-24 05:00:00	QQQ	ETF	349.68	349.96	349.65	349.78	50346.0
2021-06-24 06:00:00	QQQ	ETF	349.65	349.78	349.5	349.52	12330.0
2021-06-24 07:00:00	QQQ	ETF	349.54	349.73	349.47	349.69	96453.0
2021-06-24 08:00:00	QQQ	ETF	349.5796	349.95	348.0	349.63	274213.0
2021-06-24 09:00:00	QQQ	ETF	349.65	350.65	349.59	350.42	3413910.0
2021-06-24 10:00:00	QQQ	ETF	350.42	351.2386	350.28	350.67	4256021.0
2021-06-24 11:00:00	QQQ	ETF	350.67	350.97	350.44	350.84	2369797.0
2021-06-24 12:00:00	QQQ	ETF	350.85	351.46	350.01	350.205	3043239.0
2021-06-24 13:00:00	QQQ	ETF	350.21	350.545	349.17	349.821	3830250.0
2021-06-24 14:00:00	QQQ	ETF	349.821	350.46	349.765	350.19	2497866.0
2021-06-24 15:00:00	QQQ	ETF	350.18	350.25	349.301	349.85	4591594.0
2021-06-24 16:00:00	QQQ	ETF	349.85	350.05	349.74	349.95	677152.0
2021-06-24 17:00:00	QQQ	ETF	350.07	350.14	349.95	350.04	10583.0
2021-06-24 18:00:00	QQQ	ETF	350.04	350.1	349.79	350.1	30964.0
2021-06-24 19:00:00	QQQ	ETF	350.08	350.08	349.6399	349.66	33003.0
2021-06-24 04:00:00	IWM	ETF	229.74	229.93	229.74	229.86	15444.0
2021-06-24 05:00:00	IWM	ETF	229.89	230.26	229.87	230.15	11017.0
2021-06-24 06:00:00	IWM	ETF	230.17	230.38	230.0	230.0	11500.0
2021-06-24 07:00:00	IWM	ETF	230.01	230.21	229.9	230.16	82249.0
2021-06-24 08:00:00	IWM	ETF	230.13	230.3896	229.5	229.7	153164.0
2021-06-24 09:00:00	IWM	ETF	229.74	230.35	229.56	229.67	1853981.0
2021-06-24 10:00:00	IWM	ETF	229.67	230.31	229.49	230.04	2085405.0
2021-06-24 11:00:00	IWM	ETF	230.04	230.62	230.02	230.51	1375683.0
2021-06-24 12:00:00	IWM	ETF	230.51	231.1	230.15	230.725	1960242.0
2021-06-24 13:00:00	IWM	ETF	230.75	231.12	230.59	231.12	1836525.0
2021-06-24 14:00:00	IWM	ETF	231.11	231.71	231.08	231.55	1925278.0
2021-06-24 15:00:00	IWM	ETF	231.545	231.88	231.42	231.86	4287484.0
2021-06-24 16:00:00	IWM	ETF	231.86	232.48	231.75	232.4	2087468.0
2021-06-24 17:00:00	IWM	ETF	232.35	232.42	232.3	232.39	4448.0
2021-06-24 18:00:00	IWM	ETF	232.4	232.44	232.21	232.34	10268.0
2021-06-24 19:00:00	IWM	ETF	232.35	232.45	232.28	232.43	34097.0
2021-06-24 04:00:00	DIA	ETF	340.17	340.36	340.04	340.36	2500.0
2021-06-24 05:00:00	DIA	ETF	340.38	340.64	340.38	340.43	2594.0

> showing 50 of 14,331 rows — these rows as CSV

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