PREVIEW / etf_1hour / 2019-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-24.parquet
  size:    312 KB
  rows:    10,371

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
2019-05-24 04:00:00	SPY	ETF	283.36	283.84	283.36	283.61	25306.0
2019-05-24 05:00:00	SPY	ETF	283.64	283.83	283.45	283.66	14225.0
2019-05-24 06:00:00	SPY	ETF	283.67	284.0	283.67	283.76	86671.0
2019-05-24 07:00:00	SPY	ETF	283.72	283.91	283.28	283.29	625815.0
2019-05-24 08:00:00	SPY	ETF	283.74	283.91	282.81	283.4	370536.0
2019-05-24 09:00:00	SPY	ETF	283.41	284.2	283.37	283.61	7362443.0
2019-05-24 10:00:00	SPY	ETF	283.62	283.83	282.28	282.33	8672663.0
2019-05-24 11:00:00	SPY	ETF	282.33	282.94	282.09	282.761	6237260.0
2019-05-24 12:00:00	SPY	ETF	282.77	283.39	282.51	283.39	5399450.0
2019-05-24 13:00:00	SPY	ETF	283.39	283.49	283.0	283.1	2925854.0
2019-05-24 14:00:00	SPY	ETF	283.1	283.1599	282.68	282.95	4972810.0
2019-05-24 15:00:00	SPY	ETF	282.96	283.17	282.53	282.8	9214748.0
2019-05-24 16:00:00	SPY	ETF	282.81	283.21	282.6972	283.03	5926473.0
2019-05-24 17:00:00	SPY	ETF	283.09	283.14	282.78	283.0	2399862.0
2019-05-24 18:00:00	SPY	ETF	283.0	283.01	282.9	282.92	26248.0
2019-05-24 19:00:00	SPY	ETF	282.9101	282.99	282.9	282.96	16763.0
2019-05-24 04:00:00	QQQ	ETF	179.12	179.4	179.12	179.22	28477.0
2019-05-24 05:00:00	QQQ	ETF	179.22	179.39	179.07	179.25	14150.0
2019-05-24 06:00:00	QQQ	ETF	179.3	179.35	179.2	179.23	18159.0
2019-05-24 07:00:00	QQQ	ETF	179.22	179.29	178.79	178.82	212312.0
2019-05-24 08:00:00	QQQ	ETF	178.82	179.23	178.25	178.99	857656.0
2019-05-24 09:00:00	QQQ	ETF	178.99	179.85	178.895	179.4899	3238678.0
2019-05-24 10:00:00	QQQ	ETF	179.48	179.68	178.29	178.42	3446901.0
2019-05-24 11:00:00	QQQ	ETF	178.41	178.8691	178.18	178.685	2450025.0
2019-05-24 12:00:00	QQQ	ETF	178.69	179.07	178.41	179.01	2021071.0
2019-05-24 13:00:00	QQQ	ETF	179.03	179.1	178.565	178.67	1282942.0
2019-05-24 14:00:00	QQQ	ETF	178.67	178.7	178.275	178.48	1947461.0
2019-05-24 15:00:00	QQQ	ETF	178.475	178.6	177.94	178.12	4727761.0
2019-05-24 16:00:00	QQQ	ETF	178.12	178.36	178.02	178.19	1460811.0
2019-05-24 17:00:00	QQQ	ETF	178.12	178.31	178.12	178.19	9046.0
2019-05-24 18:00:00	QQQ	ETF	178.23	178.25	178.19	178.21	3828.0
2019-05-24 19:00:00	QQQ	ETF	178.2	178.23	178.07	178.18	13808.0
2019-05-24 04:00:00	IWM	ETF	150.17	150.48	150.17	150.48	440.0
2019-05-24 05:00:00	IWM	ETF	150.37	150.37	150.37	150.37	800.0
2019-05-24 06:00:00	IWM	ETF	150.55	150.6	150.5	150.59	11400.0
2019-05-24 07:00:00	IWM	ETF	150.54	150.55	150.23	150.25	105145.0
2019-05-24 08:00:00	IWM	ETF	150.26	150.26	150.05	150.15	127676.0
2019-05-24 09:00:00	IWM	ETF	150.25	150.99	150.25	150.9035	1774810.0
2019-05-24 10:00:00	IWM	ETF	150.91	151.09	149.95	150.06	1843522.0
2019-05-24 11:00:00	IWM	ETF	150.05	150.25	149.79	150.18	1187678.0
2019-05-24 12:00:00	IWM	ETF	150.19	150.63	150.07	150.63	1246022.0
2019-05-24 13:00:00	IWM	ETF	150.63	150.83	150.41	150.59	752370.0
2019-05-24 14:00:00	IWM	ETF	150.59	150.685	150.39	150.61	632264.0
2019-05-24 15:00:00	IWM	ETF	150.61	150.94	150.605	150.72	3092799.0
2019-05-24 16:00:00	IWM	ETF	150.735	151.07	150.735	150.99	1391778.0
2019-05-24 17:00:00	IWM	ETF	150.93	150.93	150.79	150.79	43482.0
2019-05-24 18:00:00	IWM	ETF	150.79	150.89	150.79	150.89	200.0
2019-05-24 19:00:00	IWM	ETF	150.84	150.91	150.84	150.85	2039.0
2019-05-24 04:00:00	DIA	ETF	256.21	256.24	256.21	256.24	350.0
2019-05-24 05:00:00	DIA	ETF	256.1	256.1	256.1	256.1	400.0

> showing 50 of 10,371 rows — these rows as CSV

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