PREVIEW / etf_1hour / 2021-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-06.parquet
  size:    415 KB
  rows:    14,479

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-05-06 04:00:00	SPY	ETF	416.4	416.68	415.92	416.03	12600.0
2021-05-06 05:00:00	SPY	ETF	416.08	416.35	415.38	415.97	14299.0
2021-05-06 06:00:00	SPY	ETF	415.98	416.5	415.89	415.9	23713.0
2021-05-06 07:00:00	SPY	ETF	415.85	416.28	415.71	415.95	154221.0
2021-05-06 08:00:00	SPY	ETF	415.9101	416.91	415.19	415.6	410832.0
2021-05-06 09:00:00	SPY	ETF	415.6	416.31	414.76	414.79	5509504.0
2021-05-06 10:00:00	SPY	ETF	414.79	415.3515	413.675	415.135	8835061.0
2021-05-06 11:00:00	SPY	ETF	415.13	417.58	414.24	416.895	9852666.0
2021-05-06 12:00:00	SPY	ETF	416.9	417.57	416.58	416.95	4986904.0
2021-05-06 13:00:00	SPY	ETF	416.94	417.24	416.19	416.23	4482124.0
2021-05-06 14:00:00	SPY	ETF	416.23	416.78	415.66	416.17	7571072.0
2021-05-06 15:00:00	SPY	ETF	416.17	419.21	416.02	419.08	17475749.0
2021-05-06 16:00:00	SPY	ETF	419.08	419.31	418.5459	419.24	3523181.0
2021-05-06 17:00:00	SPY	ETF	419.26	419.26	419.1	419.26	99334.0
2021-05-06 18:00:00	SPY	ETF	419.29	419.39	419.07	419.15	216594.0
2021-05-06 19:00:00	SPY	ETF	419.15	419.25	418.98	419.12	64474.0
2021-05-06 04:00:00	QQQ	ETF	330.04	330.5	329.49	329.74	51443.0
2021-05-06 05:00:00	QQQ	ETF	329.94	330.27	328.91	329.4	50790.0
2021-05-06 06:00:00	QQQ	ETF	329.47	330.28	329.4	329.44	110409.0
2021-05-06 07:00:00	QQQ	ETF	329.41	329.75	329.12	329.24	222900.0
2021-05-06 08:00:00	QQQ	ETF	329.33	330.47	328.26	328.6	309079.0
2021-05-06 09:00:00	QQQ	ETF	328.63	329.37	327.3	327.41	6626096.0
2021-05-06 10:00:00	QQQ	ETF	327.39	328.855	326.45	328.31	7371909.0
2021-05-06 11:00:00	QQQ	ETF	328.31	330.71	326.91	330.26	6187054.0
2021-05-06 12:00:00	QQQ	ETF	330.27	331.36	329.879	330.67	3181367.0
2021-05-06 13:00:00	QQQ	ETF	330.65	330.94	328.87	328.97	3158402.0
2021-05-06 14:00:00	QQQ	ETF	328.96	329.76	328.33	328.8074	4215535.0
2021-05-06 15:00:00	QQQ	ETF	328.81	331.67	328.56	331.53	6427771.0
2021-05-06 16:00:00	QQQ	ETF	331.54	331.85	331.39	331.69	1251672.0
2021-05-06 17:00:00	QQQ	ETF	331.82	332.0	331.51	331.95	317120.0
2021-05-06 18:00:00	QQQ	ETF	332.02	332.11	331.8	331.82	93309.0
2021-05-06 19:00:00	QQQ	ETF	331.82	332.05	331.76	331.9	74718.0
2021-05-06 04:00:00	IWM	ETF	223.23	223.43	222.8	222.8	8390.0
2021-05-06 05:00:00	IWM	ETF	223.07	223.14	222.4	222.87	28300.0
2021-05-06 06:00:00	IWM	ETF	223.0	223.63	222.99	223.14	10500.0
2021-05-06 07:00:00	IWM	ETF	223.07	223.33	222.93	223.13	16905.0
2021-05-06 08:00:00	IWM	ETF	223.0999	223.33	222.31	222.46	257804.0
2021-05-06 09:00:00	IWM	ETF	222.5	222.76	220.19	220.21	2205659.0
2021-05-06 10:00:00	IWM	ETF	220.2	220.61	218.97	219.76	3274972.0
2021-05-06 11:00:00	IWM	ETF	219.76	221.19	218.64	221.0789	2844588.0
2021-05-06 12:00:00	IWM	ETF	221.09	221.21	220.23	220.68	1973595.0
2021-05-06 13:00:00	IWM	ETF	220.6492	220.92	219.99	220.11	1578014.0
2021-05-06 14:00:00	IWM	ETF	220.11	220.68	219.14	219.58	2466122.0
2021-05-06 15:00:00	IWM	ETF	219.57	222.81	219.55	222.76	6403357.0
2021-05-06 16:00:00	IWM	ETF	222.75	223.07	222.51	223.04	1859854.0
2021-05-06 17:00:00	IWM	ETF	223.04	223.14	222.59	222.8	142956.0
2021-05-06 18:00:00	IWM	ETF	222.87	222.95	222.52	222.56	57075.0
2021-05-06 19:00:00	IWM	ETF	222.52	222.59	222.37	222.56	32655.0
2021-05-06 04:00:00	DIA	ETF	342.88	342.88	342.73	342.87	600.0
2021-05-06 05:00:00	DIA	ETF	342.39	342.56	342.3	342.56	1700.0

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

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