PREVIEW / etf_1hour / 2019-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-19.parquet
  size:    324 KB
  rows:    10,876

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-06-19 04:00:00	SPY	ETF	292.59	292.73	292.19	292.32	14347.0
2019-06-19 05:00:00	SPY	ETF	292.33	292.62	292.32	292.57	5861.0
2019-06-19 06:00:00	SPY	ETF	292.49	292.77	292.48	292.67	23935.0
2019-06-19 07:00:00	SPY	ETF	292.67	292.69	292.46	292.69	57907.0
2019-06-19 08:00:00	SPY	ETF	292.67	292.8	292.54	292.66	233173.0
2019-06-19 09:00:00	SPY	ETF	292.67	292.7	292.04	292.58	5084561.0
2019-06-19 10:00:00	SPY	ETF	292.58	292.65	292.04	292.199	10089757.0
2019-06-19 11:00:00	SPY	ETF	292.2	292.49	292.16	292.37	4201683.0
2019-06-19 12:00:00	SPY	ETF	292.37	292.39	292.11	292.17	3750534.0
2019-06-19 13:00:00	SPY	ETF	292.16	292.3	291.89	292.18	7782780.0
2019-06-19 14:00:00	SPY	ETF	292.19	293.5	291.47	292.87	19638200.0
2019-06-19 15:00:00	SPY	ETF	292.8625	293.65	292.8	293.05	16793707.0
2019-06-19 16:00:00	SPY	ETF	293.06	293.36	292.99	293.14	9292940.0
2019-06-19 17:00:00	SPY	ETF	293.06	293.11	292.94	292.98	199068.0
2019-06-19 18:00:00	SPY	ETF	293.0	293.72	293.0	293.68	177755.0
2019-06-19 19:00:00	SPY	ETF	293.65	294.22	293.63	294.06	112719.0
2019-06-19 04:00:00	QQQ	ETF	186.69	186.77	186.49	186.55	16741.0
2019-06-19 05:00:00	QQQ	ETF	186.55	186.66	186.38	186.63	7395.0
2019-06-19 06:00:00	QQQ	ETF	186.59	186.78	186.51	186.69	15013.0
2019-06-19 07:00:00	QQQ	ETF	186.71	186.76	186.52	186.76	40544.0
2019-06-19 08:00:00	QQQ	ETF	186.66	186.87	186.53	186.81	89123.0
2019-06-19 09:00:00	QQQ	ETF	186.8	186.85	185.75	186.25	2639364.0
2019-06-19 10:00:00	QQQ	ETF	186.28	186.34	185.9	186.04	2843293.0
2019-06-19 11:00:00	QQQ	ETF	186.04	186.38	186.03	186.3	1392986.0
2019-06-19 12:00:00	QQQ	ETF	186.29	186.34	186.0711	186.17	944578.0
2019-06-19 13:00:00	QQQ	ETF	186.16	186.23	185.84	186.11	1714348.0
2019-06-19 14:00:00	QQQ	ETF	186.14	187.53	185.57	186.585	8805273.0
2019-06-19 15:00:00	QQQ	ETF	186.58	187.52	186.53	187.12	7195160.0
2019-06-19 16:00:00	QQQ	ETF	187.12	187.3	187.08	187.16	971324.0
2019-06-19 17:00:00	QQQ	ETF	187.16	187.18	187.11	187.12	28178.0
2019-06-19 18:00:00	QQQ	ETF	187.16	187.65	187.1	187.57	51101.0
2019-06-19 19:00:00	QQQ	ETF	187.57	187.95	187.53	187.89	73908.0
2019-06-19 04:00:00	IWM	ETF	153.83	153.83	153.83	153.83	150.0
2019-06-19 05:00:00	IWM	ETF	153.91	153.91	153.91	153.91	100.0
2019-06-19 06:00:00	IWM	ETF	154.0	154.1	154.0	154.03	3950.0
2019-06-19 07:00:00	IWM	ETF	153.93	154.04	153.93	154.04	7700.0
2019-06-19 08:00:00	IWM	ETF	153.9601	154.19	153.9601	154.14	319836.0
2019-06-19 09:00:00	IWM	ETF	154.14	154.35	153.65	154.08	1052746.0
2019-06-19 10:00:00	IWM	ETF	154.08	154.215	153.775	154.1	1692236.0
2019-06-19 11:00:00	IWM	ETF	154.11	154.37	154.0	154.15	789175.0
2019-06-19 12:00:00	IWM	ETF	154.15	154.16	153.72	153.87	581677.0
2019-06-19 13:00:00	IWM	ETF	153.87	153.98	153.76	153.87	1327556.0
2019-06-19 14:00:00	IWM	ETF	153.91	154.61	153.4	154.16	2894135.0
2019-06-19 15:00:00	IWM	ETF	154.161	154.7025	154.131	154.52	3436061.0
2019-06-19 16:00:00	IWM	ETF	154.52	154.62	154.46	154.52	754534.0
2019-06-19 17:00:00	IWM	ETF	154.5359	154.56	154.5359	154.56	129148.0
2019-06-19 18:00:00	IWM	ETF	154.45	154.74	154.43	154.74	18288.0
2019-06-19 19:00:00	IWM	ETF	154.79	155.1	154.79	155.03	5529.0
2019-06-19 06:00:00	DIA	ETF	265.58	265.58	265.49	265.49	600.0
2019-06-19 07:00:00	DIA	ETF	265.5	265.59	265.41	265.59	1531.0

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

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