PREVIEW / etf_1hour / 2019-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-28.parquet
  size:    323 KB
  rows:    10,794

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-28 04:00:00	SPY	ETF	282.99	283.12	282.43	282.47	30475.0
2019-05-28 05:00:00	SPY	ETF	282.49	283.07	282.49	282.91	16211.0
2019-05-28 06:00:00	SPY	ETF	282.97	282.97	282.28	282.76	43387.0
2019-05-28 07:00:00	SPY	ETF	282.74	283.32	282.5	283.18	280876.0
2019-05-28 08:00:00	SPY	ETF	283.18	283.83	282.5899	283.08	439043.0
2019-05-28 09:00:00	SPY	ETF	283.06	284.15	283.0	283.88	6661592.0
2019-05-28 10:00:00	SPY	ETF	283.88	284.03	282.56	282.85	7052878.0
2019-05-28 11:00:00	SPY	ETF	282.84	283.3832	282.48	283.01	7677673.0
2019-05-28 12:00:00	SPY	ETF	283.01	283.38	282.86	282.91	3750957.0
2019-05-28 13:00:00	SPY	ETF	282.91	283.05	282.59	282.6135	5119440.0
2019-05-28 14:00:00	SPY	ETF	282.61	282.615	281.46	281.64	7942676.0
2019-05-28 15:00:00	SPY	ETF	281.64	281.66	280.18	280.2	22345774.0
2019-05-28 16:00:00	SPY	ETF	280.2	280.74	280.13	280.54	7389660.0
2019-05-28 17:00:00	SPY	ETF	280.52	280.59	280.15	280.42	297580.0
2019-05-28 18:00:00	SPY	ETF	280.46	280.59	280.15	280.56	112752.0
2019-05-28 19:00:00	SPY	ETF	280.54	280.65	280.28	280.48	76167.0
2019-05-28 04:00:00	QQQ	ETF	178.33	178.53	177.88	177.96	51754.0
2019-05-28 05:00:00	QQQ	ETF	178.02	178.4	178.02	178.4	77842.0
2019-05-28 06:00:00	QQQ	ETF	178.39	178.39	177.72	178.23	46230.0
2019-05-28 07:00:00	QQQ	ETF	178.28	178.7	177.99	178.57	273733.0
2019-05-28 08:00:00	QQQ	ETF	178.2299	179.02	178.07	178.5	228044.0
2019-05-28 09:00:00	QQQ	ETF	178.51	179.66	178.45	179.325	2732395.0
2019-05-28 10:00:00	QQQ	ETF	179.35	179.44	178.44	178.7	3595576.0
2019-05-28 11:00:00	QQQ	ETF	178.68	179.15	178.46	179.04	2478212.0
2019-05-28 12:00:00	QQQ	ETF	179.0401	179.25	178.89	178.925	1864873.0
2019-05-28 13:00:00	QQQ	ETF	178.9275	179.03	178.68	178.815	1342053.0
2019-05-28 14:00:00	QQQ	ETF	178.8	178.81	178.02	178.1808	2889943.0
2019-05-28 15:00:00	QQQ	ETF	178.17	178.19	177.47	177.5	6035932.0
2019-05-28 16:00:00	QQQ	ETF	177.51	177.85	177.48	177.7	990218.0
2019-05-28 17:00:00	QQQ	ETF	177.61	177.68	177.51	177.63	15520.0
2019-05-28 18:00:00	QQQ	ETF	177.64	177.79	177.53	177.65	26461.0
2019-05-28 19:00:00	QQQ	ETF	177.74	177.79	177.49	177.63	38371.0
2019-05-28 04:00:00	IWM	ETF	150.87	150.87	150.58	150.58	2900.0
2019-05-28 05:00:00	IWM	ETF	150.62	150.83	150.62	150.82	8200.0
2019-05-28 06:00:00	IWM	ETF	150.84	150.84	150.69	150.69	1300.0
2019-05-28 07:00:00	IWM	ETF	150.68	151.04	150.67	151.03	19796.0
2019-05-28 08:00:00	IWM	ETF	150.77	151.18	150.67	151.0	9917.0
2019-05-28 09:00:00	IWM	ETF	150.99	151.65	150.97	151.18	1412781.0
2019-05-28 10:00:00	IWM	ETF	151.17	151.33	150.23	150.515	2046335.0
2019-05-28 11:00:00	IWM	ETF	150.51	151.08	150.3	150.82	1591969.0
2019-05-28 12:00:00	IWM	ETF	150.81	151.26	150.68	150.97	1033545.0
2019-05-28 13:00:00	IWM	ETF	150.96	151.055	150.69	150.77	528598.0
2019-05-28 14:00:00	IWM	ETF	150.77	150.77	150.085	150.2	1033698.0
2019-05-28 15:00:00	IWM	ETF	150.2	150.2	149.62	149.63	4108779.0
2019-05-28 16:00:00	IWM	ETF	149.62	150.0	149.58	149.88	1073944.0
2019-05-28 17:00:00	IWM	ETF	149.79	149.88	149.79	149.88	447.0
2019-05-28 18:00:00	IWM	ETF	149.87	149.88	149.59	149.88	46168.0
2019-05-28 19:00:00	IWM	ETF	149.88	149.88	149.78	149.85	7250.0
2019-05-28 04:00:00	DIA	ETF	256.25	256.25	255.9	255.9	2455.0
2019-05-28 07:00:00	DIA	ETF	256.17	256.2	256.0	256.2	9800.0

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

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