PREVIEW / etf_1hour / 2021-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-19.parquet
  size:    445 KB
  rows:    16,040

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-07-19 04:00:00	SPY	ETF	429.28	429.97	428.09	428.25	58461.0
2021-07-19 05:00:00	SPY	ETF	428.13	428.86	428.13	428.7	67396.0
2021-07-19 06:00:00	SPY	ETF	428.8	428.8	427.9	428.07	69601.0
2021-07-19 07:00:00	SPY	ETF	428.11	428.34	426.26	426.96	742893.0
2021-07-19 08:00:00	SPY	ETF	426.98	430.3	425.89	426.45	1701497.0
2021-07-19 09:00:00	SPY	ETF	426.42	426.71	423.95	424.27	15197024.0
2021-07-19 10:00:00	SPY	ETF	424.25	424.59	422.665	424.1119	19664600.0
2021-07-19 11:00:00	SPY	ETF	424.12	425.38	423.58	424.925	12084432.0
2021-07-19 12:00:00	SPY	ETF	424.92	424.92	422.26	422.855	11648881.0
2021-07-19 13:00:00	SPY	ETF	422.84	423.46	421.97	422.135	11303748.0
2021-07-19 14:00:00	SPY	ETF	422.13	423.41	421.97	422.3999	11777472.0
2021-07-19 15:00:00	SPY	ETF	422.39	425.01	422.185	424.96	28382178.0
2021-07-19 16:00:00	SPY	ETF	424.96	426.0	423.9397	425.57	6645741.0
2021-07-19 17:00:00	SPY	ETF	425.47	425.7	425.45	425.69	196123.0
2021-07-19 18:00:00	SPY	ETF	425.75	425.79	425.32	425.6	100678.0
2021-07-19 19:00:00	SPY	ETF	425.65	425.94	425.46	425.75	250370.0
2021-07-19 04:00:00	QQQ	ETF	357.14	357.4	355.94	356.12	114168.0
2021-07-19 05:00:00	QQQ	ETF	356.01	356.6	355.82	356.39	145504.0
2021-07-19 06:00:00	QQQ	ETF	356.53	356.69	356.0	356.23	135423.0
2021-07-19 07:00:00	QQQ	ETF	356.26	356.32	353.96	354.59	595401.0
2021-07-19 08:00:00	QQQ	ETF	356.1604	357.868	353.47	354.38	768235.0
2021-07-19 09:00:00	QQQ	ETF	354.3	355.15	352.67	352.96	8152827.0
2021-07-19 10:00:00	QQQ	ETF	352.96	353.81	352.04	353.77	9414032.0
2021-07-19 11:00:00	QQQ	ETF	353.8	355.18	353.41	354.2475	6086159.0
2021-07-19 12:00:00	QQQ	ETF	354.25	354.31	352.32	352.75	4804545.0
2021-07-19 13:00:00	QQQ	ETF	352.74	353.39	352.09	352.51	5136652.0
2021-07-19 14:00:00	QQQ	ETF	352.49	353.87	352.4701	353.03	4065159.0
2021-07-19 15:00:00	QQQ	ETF	353.05	354.7	352.3	354.68	8364368.0
2021-07-19 16:00:00	QQQ	ETF	354.68	355.7	354.36	354.67	1679141.0
2021-07-19 17:00:00	QQQ	ETF	355.75	355.75	354.67	355.7	95247.0
2021-07-19 18:00:00	QQQ	ETF	355.74	355.74	355.3	355.53	63800.0
2021-07-19 19:00:00	QQQ	ETF	355.6	355.72	355.36	355.59	74907.0
2021-07-19 04:00:00	IWM	ETF	212.62	213.02	211.3	211.44	99858.0
2021-07-19 05:00:00	IWM	ETF	211.54	211.95	211.42	211.6	65496.0
2021-07-19 06:00:00	IWM	ETF	211.65	211.65	210.66	210.91	93157.0
2021-07-19 07:00:00	IWM	ETF	210.95	211.3	209.74	210.52	460332.0
2021-07-19 08:00:00	IWM	ETF	210.53	213.73	209.49	210.72	462975.0
2021-07-19 09:00:00	IWM	ETF	210.67	211.48	209.63	209.99	7372701.0
2021-07-19 10:00:00	IWM	ETF	209.92	212.45	209.05	211.51	7246522.0
2021-07-19 11:00:00	IWM	ETF	211.52	214.445	211.37	214.28	6390622.0
2021-07-19 12:00:00	IWM	ETF	214.27	214.27	211.17	211.575	5145670.0
2021-07-19 13:00:00	IWM	ETF	211.57	212.55	210.51	210.77	5491301.0
2021-07-19 14:00:00	IWM	ETF	210.78	211.82	210.01	210.38	4969702.0
2021-07-19 15:00:00	IWM	ETF	210.38	211.83	210.02	211.81	8619276.0
2021-07-19 16:00:00	IWM	ETF	211.8	212.48	211.4106	212.44	1454834.0
2021-07-19 17:00:00	IWM	ETF	212.33	212.75	211.73	212.75	230478.0
2021-07-19 18:00:00	IWM	ETF	212.64	212.72	212.5	212.71	41536.0
2021-07-19 19:00:00	IWM	ETF	212.75	213.07	212.71	213.01	43454.0
2021-07-19 04:00:00	DIA	ETF	344.28	344.91	343.35	343.35	7635.0
2021-07-19 05:00:00	DIA	ETF	343.18	343.69	343.18	343.69	10717.0

> showing 50 of 16,040 rows — these rows as CSV

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