PREVIEW / etf_1hour / 2019-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-14.parquet
  size:    333 KB
  rows:    10,862

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-14 04:00:00	SPY	ETF	281.77	282.0	281.44	281.88	24785.0
2019-05-14 05:00:00	SPY	ETF	281.85	282.37	281.75	282.29	14232.0
2019-05-14 06:00:00	SPY	ETF	282.29	282.82	282.11	282.34	146091.0
2019-05-14 07:00:00	SPY	ETF	282.28	282.85	282.2	282.56	582927.0
2019-05-14 08:00:00	SPY	ETF	282.29	282.84	281.68	282.27	802091.0
2019-05-14 09:00:00	SPY	ETF	282.28	282.97	280.86	282.36	8059981.0
2019-05-14 10:00:00	SPY	ETF	282.37	283.68	282.36	283.39	12538861.0
2019-05-14 11:00:00	SPY	ETF	283.39	284.73	283.07	284.54	10034276.0
2019-05-14 12:00:00	SPY	ETF	284.54	284.77	284.03	284.32	6836714.0
2019-05-14 13:00:00	SPY	ETF	284.325	285.1	284.325	284.86	4721286.0
2019-05-14 14:00:00	SPY	ETF	284.86	285.05	284.03	284.315	8734052.0
2019-05-14 15:00:00	SPY	ETF	284.31	284.77	283.17	283.33	17722882.0
2019-05-14 16:00:00	SPY	ETF	283.32	283.82	283.27	283.72	3138481.0
2019-05-14 17:00:00	SPY	ETF	283.73	283.73	283.4	283.73	206482.0
2019-05-14 18:00:00	SPY	ETF	283.73	284.0	283.4	283.85	131082.0
2019-05-14 19:00:00	SPY	ETF	283.85	283.93	283.71	283.91	45504.0
2019-05-14 04:00:00	QQQ	ETF	179.05	179.43	179.05	179.42	79499.0
2019-05-14 05:00:00	QQQ	ETF	179.42	179.8	179.37	179.72	45659.0
2019-05-14 06:00:00	QQQ	ETF	179.72	180.05	179.6	179.75	121013.0
2019-05-14 07:00:00	QQQ	ETF	179.7	180.16	179.7	179.91	391387.0
2019-05-14 08:00:00	QQQ	ETF	179.75	180.15	179.0	179.76	457123.0
2019-05-14 09:00:00	QQQ	ETF	179.76	180.06	178.86	179.27	5623540.0
2019-05-14 10:00:00	QQQ	ETF	179.27	180.54	179.25	180.27	6794597.0
2019-05-14 11:00:00	QQQ	ETF	180.27	181.32	179.91	181.15	5281085.0
2019-05-14 12:00:00	QQQ	ETF	181.16	181.47	180.82	181.075	3265871.0
2019-05-14 13:00:00	QQQ	ETF	181.08	181.63	181.08	181.49	2124273.0
2019-05-14 14:00:00	QQQ	ETF	181.48	181.55	180.84	181.09	3718114.0
2019-05-14 15:00:00	QQQ	ETF	181.08	181.4	180.4	180.49	6358824.0
2019-05-14 16:00:00	QQQ	ETF	180.49	180.82	180.4	180.8	4193832.0
2019-05-14 17:00:00	QQQ	ETF	180.8	180.95	180.62	180.76	22122.0
2019-05-14 18:00:00	QQQ	ETF	180.79	181.02	180.54	180.92	76361.0
2019-05-14 19:00:00	QQQ	ETF	180.91	180.96	180.82	180.94	18688.0
2019-05-14 04:00:00	IWM	ETF	152.1	152.48	151.89	151.96	6310.0
2019-05-14 05:00:00	IWM	ETF	152.11	152.49	152.11	152.32	14000.0
2019-05-14 06:00:00	IWM	ETF	152.29	152.5	152.29	152.5	7751.0
2019-05-14 07:00:00	IWM	ETF	152.26	152.5	152.2	152.22	30020.0
2019-05-14 08:00:00	IWM	ETF	152.37	152.37	151.8	152.01	41462.0
2019-05-14 09:00:00	IWM	ETF	152.02	152.6	151.7	151.99	2075150.0
2019-05-14 10:00:00	IWM	ETF	151.99	152.94	151.99	152.7298	2552587.0
2019-05-14 11:00:00	IWM	ETF	152.73	153.56	152.5	153.47	2299056.0
2019-05-14 12:00:00	IWM	ETF	153.46	153.625	153.21	153.48	1161474.0
2019-05-14 13:00:00	IWM	ETF	153.5	153.99	153.5	153.85	990570.0
2019-05-14 14:00:00	IWM	ETF	153.85	154.17	153.58	153.785	1214397.0
2019-05-14 15:00:00	IWM	ETF	153.76	154.09	153.43	153.58	2534869.0
2019-05-14 16:00:00	IWM	ETF	153.58	153.79	153.48	153.69	349936.0
2019-05-14 17:00:00	IWM	ETF	153.79	153.79	153.54	153.54	36272.0
2019-05-14 18:00:00	IWM	ETF	153.64	153.8	153.54	153.8	69756.0
2019-05-14 19:00:00	IWM	ETF	153.75	153.82	153.75	153.82	494.0
2019-05-14 04:00:00	DIA	ETF	254.02	254.26	254.02	254.26	200.0
2019-05-14 05:00:00	DIA	ETF	254.3	254.52	254.3	254.52	16050.0

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

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