PREVIEW / etf_1hour / 2019-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-25.parquet
  size:    322 KB
  rows:    10,757

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-03-25 04:00:00	SPY	ETF	278.5	279.04	278.43	278.6	25322.0
2019-03-25 05:00:00	SPY	ETF	278.79	279.5	278.79	279.32	36627.0
2019-03-25 06:00:00	SPY	ETF	279.3	279.67	279.16	279.33	111597.0
2019-03-25 07:00:00	SPY	ETF	279.34	279.41	278.92	278.93	215012.0
2019-03-25 08:00:00	SPY	ETF	278.98	279.6	277.8	279.48	626426.0
2019-03-25 09:00:00	SPY	ETF	279.48	280.02	277.94	277.99	13227492.0
2019-03-25 10:00:00	SPY	ETF	278.0	279.6	277.71	279.36	13163700.0
2019-03-25 11:00:00	SPY	ETF	279.36	280.1853	278.92	278.95	10513717.0
2019-03-25 12:00:00	SPY	ETF	278.94	279.55	278.31	279.08	9148184.0
2019-03-25 13:00:00	SPY	ETF	279.09	279.42	278.03	278.17	6614235.0
2019-03-25 14:00:00	SPY	ETF	278.17	278.81	277.64	278.75	9257098.0
2019-03-25 15:00:00	SPY	ETF	278.75	279.45	278.56	279.03	13867702.0
2019-03-25 16:00:00	SPY	ETF	279.03	279.55	278.93	279.53	7244699.0
2019-03-25 17:00:00	SPY	ETF	279.53	279.53	279.38	279.52	423243.0
2019-03-25 18:00:00	SPY	ETF	279.52	279.55	279.32	279.32	37903.0
2019-03-25 19:00:00	SPY	ETF	279.04	279.79	279.04	279.69	254009.0
2019-03-25 04:00:00	QQQ	ETF	177.38	177.85	177.38	177.51	41270.0
2019-03-25 05:00:00	QQQ	ETF	177.57	178.15	177.57	178.02	51900.0
2019-03-25 06:00:00	QQQ	ETF	178.05	178.28	177.91	178.04	81449.0
2019-03-25 07:00:00	QQQ	ETF	178.07	178.07	177.73	177.8	154364.0
2019-03-25 08:00:00	QQQ	ETF	177.91	178.58	177.1	178.47	537557.0
2019-03-25 09:00:00	QQQ	ETF	178.48	178.84	177.16	177.2999	7501171.0
2019-03-25 10:00:00	QQQ	ETF	177.3	178.32	176.93	178.15	7985637.0
2019-03-25 11:00:00	QQQ	ETF	178.14	178.74	177.92	177.94	4491884.0
2019-03-25 12:00:00	QQQ	ETF	177.94	178.5	177.59	178.05	2548399.0
2019-03-25 13:00:00	QQQ	ETF	178.06	178.3	177.23	177.36	3522380.0
2019-03-25 14:00:00	QQQ	ETF	177.34	177.89	177.08	177.86	3513524.0
2019-03-25 15:00:00	QQQ	ETF	177.8601	178.48	177.76	178.24	5719136.0
2019-03-25 16:00:00	QQQ	ETF	178.23	178.62	178.12	178.61	1023780.0
2019-03-25 17:00:00	QQQ	ETF	178.53	178.69	178.5	178.55	12754.0
2019-03-25 18:00:00	QQQ	ETF	178.54	178.55	178.4	178.4	33666.0
2019-03-25 19:00:00	QQQ	ETF	178.4	178.75	178.37	178.71	33993.0
2019-03-25 04:00:00	IWM	ETF	149.3	149.32	149.19	149.19	2700.0
2019-03-25 05:00:00	IWM	ETF	149.76	149.81	149.54	149.81	9300.0
2019-03-25 06:00:00	IWM	ETF	149.66	149.93	149.66	149.93	6898.0
2019-03-25 07:00:00	IWM	ETF	149.54	149.65	149.49	149.52	17880.0
2019-03-25 08:00:00	IWM	ETF	149.66	149.85	149.55	149.7	111556.0
2019-03-25 09:00:00	IWM	ETF	149.68	149.99	148.62	148.86	4108474.0
2019-03-25 10:00:00	IWM	ETF	148.86	149.88	148.405	149.55	3904858.0
2019-03-25 11:00:00	IWM	ETF	149.53	151.32	149.48	150.11	4636202.0
2019-03-25 12:00:00	IWM	ETF	150.11	150.6	149.74	150.47	1807375.0
2019-03-25 13:00:00	IWM	ETF	150.47	150.58	149.81	149.85	1632896.0
2019-03-25 14:00:00	IWM	ETF	149.85	150.47	149.46	150.4	2176877.0
2019-03-25 15:00:00	IWM	ETF	150.4	150.87	150.25	150.27	4523966.0
2019-03-25 16:00:00	IWM	ETF	150.27	150.65	150.19	150.65	1099243.0
2019-03-25 17:00:00	IWM	ETF	150.51	150.67	150.51	150.67	2205.0
2019-03-25 19:00:00	IWM	ETF	150.6	150.83	150.58	150.81	11208.0
2019-03-25 04:00:00	DIA	ETF	254.74	254.74	254.4	254.7	300.0
2019-03-25 05:00:00	DIA	ETF	255.16	255.16	254.86	254.98	700.0
2019-03-25 06:00:00	DIA	ETF	254.94	255.26	254.94	255.2	16000.0

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

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