PREVIEW / etf_1hour / 2020-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-12.parquet
  size:    368 KB
  rows:    12,575

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
2020-05-12 04:00:00	SPY	ETF	291.82	292.2	291.37	291.75	34073.0
2020-05-12 05:00:00	SPY	ETF	291.65	292.5	291.33	292.48	90774.0
2020-05-12 06:00:00	SPY	ETF	292.4	293.29	292.23	293.0	124729.0
2020-05-12 07:00:00	SPY	ETF	293.04	293.93	292.94	293.83	533757.0
2020-05-12 08:00:00	SPY	ETF	293.76	293.89	290.31	293.77	432096.0
2020-05-12 09:00:00	SPY	ETF	293.8	294.24	291.54	292.283	9140269.0
2020-05-12 10:00:00	SPY	ETF	292.28	292.77	291.61	292.53	10337105.0
2020-05-12 11:00:00	SPY	ETF	292.54	293.13	291.95	292.51	6367730.0
2020-05-12 12:00:00	SPY	ETF	292.52	292.64	292.0	292.51	4628067.0
2020-05-12 13:00:00	SPY	ETF	292.5	292.56	290.5	291.484	8033706.0
2020-05-12 14:00:00	SPY	ETF	291.4742	291.56	290.24	291.04	9253329.0
2020-05-12 15:00:00	SPY	ETF	291.04	291.12	286.55	286.62	34197308.0
2020-05-12 16:00:00	SPY	ETF	286.59	286.67	284.13	284.3	10076616.0
2020-05-12 17:00:00	SPY	ETF	284.32	286.67	283.9	284.49	618261.0
2020-05-12 18:00:00	SPY	ETF	284.45	286.6721	283.68	284.64	806816.0
2020-05-12 19:00:00	SPY	ETF	284.68	284.95	283.1	283.3	568665.0
2020-05-12 04:00:00	QQQ	ETF	226.42	226.65	226.14	226.22	38135.0
2020-05-12 05:00:00	QQQ	ETF	226.11	226.47	225.74	226.46	26843.0
2020-05-12 06:00:00	QQQ	ETF	226.5	227.1	226.3	227.0	45044.0
2020-05-12 07:00:00	QQQ	ETF	226.85	227.58	226.79	227.4	163620.0
2020-05-12 08:00:00	QQQ	ETF	227.4	227.56	225.72	227.44	322351.0
2020-05-12 09:00:00	QQQ	ETF	227.47	228.095	225.46	226.265	5498687.0
2020-05-12 10:00:00	QQQ	ETF	226.28	227.43	225.8201	227.24	4957182.0
2020-05-12 11:00:00	QQQ	ETF	227.25	227.78	226.82	227.26	3521140.0
2020-05-12 12:00:00	QQQ	ETF	227.28	227.75	226.95	227.68	2761787.0
2020-05-12 13:00:00	QQQ	ETF	227.665	227.685	225.86	226.79	3314179.0
2020-05-12 14:00:00	QQQ	ETF	226.8	226.84	225.7779	226.36	3262690.0
2020-05-12 15:00:00	QQQ	ETF	226.31	226.4	222.09	222.14	12524299.0
2020-05-12 16:00:00	QQQ	ETF	222.14	226.8	220.66	220.73	1124169.0
2020-05-12 17:00:00	QQQ	ETF	220.85	221.0	220.67	220.93	93928.0
2020-05-12 18:00:00	QQQ	ETF	220.91	221.52	220.5	220.92	224600.0
2020-05-12 19:00:00	QQQ	ETF	220.82	221.05	219.88	220.05	162863.0
2020-05-12 04:00:00	IWM	ETF	130.75	131.26	130.65	131.15	8516.0
2020-05-12 05:00:00	IWM	ETF	131.03	131.57	130.83	131.53	19325.0
2020-05-12 06:00:00	IWM	ETF	131.6	132.37	131.52	131.97	44711.0
2020-05-12 07:00:00	IWM	ETF	131.9	132.73	131.85	132.64	91614.0
2020-05-12 08:00:00	IWM	ETF	131.9699	132.75	130.51	132.4	108838.0
2020-05-12 09:00:00	IWM	ETF	132.4	132.48	129.43	130.395	5273835.0
2020-05-12 10:00:00	IWM	ETF	130.43	130.99	129.76	130.55	4695875.0
2020-05-12 11:00:00	IWM	ETF	130.55	131.07	130.22	130.885	2277603.0
2020-05-12 12:00:00	IWM	ETF	130.885	131.31	130.3	131.23	1771110.0
2020-05-12 13:00:00	IWM	ETF	131.22	131.29	129.86	130.64	3228537.0
2020-05-12 14:00:00	IWM	ETF	130.64	130.7	129.45	129.56	3732070.0
2020-05-12 15:00:00	IWM	ETF	129.55	129.91	126.84	126.9	12811367.0
2020-05-12 16:00:00	IWM	ETF	126.9	127.11	125.13	125.19	4404529.0
2020-05-12 17:00:00	IWM	ETF	125.29	126.97	125.11	125.6	179729.0
2020-05-12 18:00:00	IWM	ETF	125.41	125.89	124.85	125.35	176011.0
2020-05-12 19:00:00	IWM	ETF	125.269	125.65	124.67	124.79	53253.0
2020-05-12 04:00:00	DIA	ETF	241.8	242.04	241.54	241.96	900.0
2020-05-12 05:00:00	DIA	ETF	241.47	242.11	241.47	241.93	1560.0

> showing 50 of 12,575 rows — these rows as CSV

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