PREVIEW / etf_1hour / 2018-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-15.parquet
  size:    319 KB
  rows:    10,610

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
2018-11-15 04:00:00	SPY	ETF	270.23	270.55	269.7	269.77	59727.0
2018-11-15 05:00:00	SPY	ETF	269.77	270.56	269.32	270.5	154524.0
2018-11-15 06:00:00	SPY	ETF	270.52	270.89	270.3	270.6	139610.0
2018-11-15 07:00:00	SPY	ETF	270.57	270.83	270.05	270.06	510966.0
2018-11-15 08:00:00	SPY	ETF	270.06	270.77	269.14	269.55	901025.0
2018-11-15 09:00:00	SPY	ETF	269.45	269.71	267.66	268.59	13032756.0
2018-11-15 10:00:00	SPY	ETF	268.61	269.24	267.0102	268.54	18802554.0
2018-11-15 11:00:00	SPY	ETF	268.52	270.77	268.31	270.415	14786329.0
2018-11-15 12:00:00	SPY	ETF	270.419	270.95	269.47	269.6836	11389055.0
2018-11-15 13:00:00	SPY	ETF	269.68	272.71	269.06	272.4525	18827832.0
2018-11-15 14:00:00	SPY	ETF	272.4515	273.54	271.96	272.66	13923179.0
2018-11-15 15:00:00	SPY	ETF	272.66	273.09	271.03	273.04	28307127.0
2018-11-15 16:00:00	SPY	ETF	273.03	273.48	272.65	273.22	11119880.0
2018-11-15 17:00:00	SPY	ETF	273.13	273.2	272.88	272.96	2017375.0
2018-11-15 18:00:00	SPY	ETF	272.97	273.01	272.39	272.52	230746.0
2018-11-15 19:00:00	SPY	ETF	272.42	272.92	272.41	272.73	74415.0
2018-11-15 04:00:00	QQQ	ETF	166.0	166.21	165.28	165.35	86204.0
2018-11-15 05:00:00	QQQ	ETF	165.21	165.96	165.01	165.94	112201.0
2018-11-15 06:00:00	QQQ	ETF	166.0	166.23	165.7	165.95	116383.0
2018-11-15 07:00:00	QQQ	ETF	165.95	166.19	165.53	165.54	234452.0
2018-11-15 08:00:00	QQQ	ETF	165.915	166.68	164.83	165.11	448888.0
2018-11-15 09:00:00	QQQ	ETF	165.1	165.88	164.05	164.64	6942689.0
2018-11-15 10:00:00	QQQ	ETF	164.65	165.1	163.46	164.76	7456420.0
2018-11-15 11:00:00	QQQ	ETF	164.76	166.22	164.52	165.89	8364414.0
2018-11-15 12:00:00	QQQ	ETF	165.9	166.365	165.31	165.52	4305685.0
2018-11-15 13:00:00	QQQ	ETF	165.51	167.76	165.1	167.619	10036810.0
2018-11-15 14:00:00	QQQ	ETF	167.62	168.54	167.37	168.0061	5415367.0
2018-11-15 15:00:00	QQQ	ETF	167.99	168.21	166.76	168.09	13754282.0
2018-11-15 16:00:00	QQQ	ETF	168.1	168.43	167.35	167.67	4087289.0
2018-11-15 17:00:00	QQQ	ETF	167.51	168.09	167.24	167.35	642000.0
2018-11-15 18:00:00	QQQ	ETF	167.35	167.43	167.13	167.32	160081.0
2018-11-15 19:00:00	QQQ	ETF	167.25	167.62	167.2	167.33	51067.0
2018-11-15 04:00:00	IWM	ETF	149.55	149.55	149.09	149.09	497.0
2018-11-15 05:00:00	IWM	ETF	149.46	149.46	149.33	149.4	2700.0
2018-11-15 06:00:00	IWM	ETF	149.5	149.74	149.49	149.49	3367.0
2018-11-15 07:00:00	IWM	ETF	149.6	149.67	149.15	149.15	11096.0
2018-11-15 08:00:00	IWM	ETF	149.44	149.62	148.72	148.89	123914.0
2018-11-15 09:00:00	IWM	ETF	148.91	149.5	148.23	148.42	2651500.0
2018-11-15 10:00:00	IWM	ETF	148.39	149.29	148.13	148.79	2868660.0
2018-11-15 11:00:00	IWM	ETF	148.8	150.44	148.46	150.36	3077567.0
2018-11-15 12:00:00	IWM	ETF	150.36	150.55	149.57	149.74	2146278.0
2018-11-15 13:00:00	IWM	ETF	149.73	151.43	149.24	151.275	3229548.0
2018-11-15 14:00:00	IWM	ETF	151.28	151.8	150.99	151.47	2057113.0
2018-11-15 15:00:00	IWM	ETF	151.475	151.65	150.72	151.61	4606032.0
2018-11-15 16:00:00	IWM	ETF	151.58	152.0	151.41	151.79	956509.0
2018-11-15 17:00:00	IWM	ETF	151.61	151.61	151.51	151.51	1126663.0
2018-11-15 18:00:00	IWM	ETF	151.6	151.67	151.32	151.32	7800.0
2018-11-15 19:00:00	IWM	ETF	151.32	151.5	151.25	151.32	3100.0
2018-11-15 04:00:00	DIA	ETF	251.43	251.43	250.78	250.78	590.0
2018-11-15 05:00:00	DIA	ETF	250.64	251.55	250.64	251.55	1000.0

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

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