PREVIEW / etf_1hour / 2019-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-27.parquet
  size:    319 KB
  rows:    10,643

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-27 04:00:00	SPY	ETF	281.77	281.78	281.25	281.3	10996.0
2019-03-27 05:00:00	SPY	ETF	281.22	281.67	280.79	280.85	10851.0
2019-03-27 06:00:00	SPY	ETF	280.7	280.72	280.24	280.24	68640.0
2019-03-27 07:00:00	SPY	ETF	280.25	280.75	280.15	280.65	138367.0
2019-03-27 08:00:00	SPY	ETF	280.7	281.77	280.1901	281.12	457512.0
2019-03-27 09:00:00	SPY	ETF	281.08	281.76	280.5415	280.69	5979268.0
2019-03-27 10:00:00	SPY	ETF	280.695	281.56	279.78	280.12	9995234.0
2019-03-27 11:00:00	SPY	ETF	280.12	280.35	277.93	278.35	13063485.0
2019-03-27 12:00:00	SPY	ETF	278.34	279.34	278.12	278.97	8104516.0
2019-03-27 13:00:00	SPY	ETF	278.96	280.01	278.67	279.76	7938966.0
2019-03-27 14:00:00	SPY	ETF	279.77	280.2	279.41	279.69	6363757.0
2019-03-27 15:00:00	SPY	ETF	279.7	280.35	279.38	279.72	14374746.0
2019-03-27 16:00:00	SPY	ETF	279.72	279.96	279.47	279.47	4406224.0
2019-03-27 17:00:00	SPY	ETF	279.45	279.56	279.44	279.54	82800.0
2019-03-27 18:00:00	SPY	ETF	279.5	279.54	279.2	279.35	61689.0
2019-03-27 19:00:00	SPY	ETF	279.31	279.46	279.14	279.37	46591.0
2019-03-27 04:00:00	QQQ	ETF	179.63	179.63	179.31	179.35	15646.0
2019-03-27 05:00:00	QQQ	ETF	179.37	179.6	179.06	179.09	22234.0
2019-03-27 06:00:00	QQQ	ETF	179.08	179.08	178.75	178.75	14434.0
2019-03-27 07:00:00	QQQ	ETF	178.8	179.06	178.72	178.99	44548.0
2019-03-27 08:00:00	QQQ	ETF	178.71	179.54	178.7	179.24	211947.0
2019-03-27 09:00:00	QQQ	ETF	179.23	179.72	178.73	178.82	4162479.0
2019-03-27 10:00:00	QQQ	ETF	178.82	179.5	178.23	178.55	5007285.0
2019-03-27 11:00:00	QQQ	ETF	178.53	178.73	176.6	176.88	6613887.0
2019-03-27 12:00:00	QQQ	ETF	176.87	177.67	176.74	177.34	3768952.0
2019-03-27 13:00:00	QQQ	ETF	177.34	178.2374	177.15	178.0	2846474.0
2019-03-27 14:00:00	QQQ	ETF	178.01	178.32	177.55	177.85	3863288.0
2019-03-27 15:00:00	QQQ	ETF	177.86	178.37	177.62	178.0	4959149.0
2019-03-27 16:00:00	QQQ	ETF	178.01	178.2	177.74	177.74	1061380.0
2019-03-27 17:00:00	QQQ	ETF	177.69	177.9	177.69	177.76	62088.0
2019-03-27 18:00:00	QQQ	ETF	177.75	177.77	177.54	177.65	51253.0
2019-03-27 19:00:00	QQQ	ETF	177.69	177.73	177.5	177.64	28678.0
2019-03-27 04:00:00	IWM	ETF	152.13	152.13	152.13	152.13	400.0
2019-03-27 06:00:00	IWM	ETF	151.4	151.4	151.4	151.4	100.0
2019-03-27 07:00:00	IWM	ETF	151.49	151.65	151.49	151.65	2001.0
2019-03-27 08:00:00	IWM	ETF	151.6301	151.92	151.3	151.73	39399.0
2019-03-27 09:00:00	IWM	ETF	151.73	152.21	151.2	151.3	2092800.0
2019-03-27 10:00:00	IWM	ETF	151.3	151.81	150.66	150.96	2975138.0
2019-03-27 11:00:00	IWM	ETF	150.9517	151.06	149.48	149.93	3934138.0
2019-03-27 12:00:00	IWM	ETF	149.93	151.26	149.73	150.89	2897569.0
2019-03-27 13:00:00	IWM	ETF	150.89	151.58	150.56	151.42	2241436.0
2019-03-27 14:00:00	IWM	ETF	151.43	151.73	151.07	151.19	2872660.0
2019-03-27 15:00:00	IWM	ETF	151.22	151.86	151.02	151.27	2529938.0
2019-03-27 16:00:00	IWM	ETF	151.27	151.38	151.08	151.08	596677.0
2019-03-27 17:00:00	IWM	ETF	151.08	151.14	151.05	151.08	3381.0
2019-03-27 18:00:00	IWM	ETF	151.08	151.14	150.97	150.99	14635.0
2019-03-27 19:00:00	IWM	ETF	150.99	151.07	150.94	151.07	3324.0
2019-03-27 04:00:00	DIA	ETF	256.56	256.56	256.56	256.56	110.0
2019-03-27 05:00:00	DIA	ETF	256.48	256.48	256.48	256.48	1000.0
2019-03-27 06:00:00	DIA	ETF	255.76	255.9	255.76	255.76	2000.0

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

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