PREVIEW / etf_1hour / 2018-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-04.parquet
  size:    334 KB
  rows:    10,916

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-12-04 04:00:00	SPY	ETF	278.04	278.06	277.51	277.64	27836.0
2018-12-04 05:00:00	SPY	ETF	277.55	278.37	277.48	278.24	36747.0
2018-12-04 06:00:00	SPY	ETF	278.3	278.5	278.16	278.22	68817.0
2018-12-04 07:00:00	SPY	ETF	278.22	278.4	277.9	278.18	308009.0
2018-12-04 08:00:00	SPY	ETF	278.1001	279.3	276.98	278.68	463761.0
2018-12-04 09:00:00	SPY	ETF	278.64	278.85	277.34	277.75	10249199.0
2018-12-04 10:00:00	SPY	ETF	277.76	277.98	277.09	277.23	10648944.0
2018-12-04 11:00:00	SPY	ETF	277.24	277.6	276.41	276.45	9845555.0
2018-12-04 12:00:00	SPY	ETF	276.44	276.4471	272.25	272.99	34414688.0
2018-12-04 13:00:00	SPY	ETF	272.96	273.23	270.38	272.24	23504769.0
2018-12-04 14:00:00	SPY	ETF	272.24	273.35	271.62	272.3001	18347440.0
2018-12-04 15:00:00	SPY	ETF	272.31	272.33	269.9	270.49	44030600.0
2018-12-04 16:00:00	SPY	ETF	270.48	270.67	269.74	270.35	19325362.0
2018-12-04 17:00:00	SPY	ETF	270.27	279.2317	270.05	270.06	859399.0
2018-12-04 18:00:00	SPY	ETF	270.08	271.0199	269.95	271.0199	1356848.0
2018-12-04 19:00:00	SPY	ETF	271.02	271.51	270.84	271.0	481942.0
2018-12-04 04:00:00	QQQ	ETF	171.06	171.07	170.59	170.74	23962.0
2018-12-04 05:00:00	QQQ	ETF	170.7	171.3	170.65	171.15	27873.0
2018-12-04 06:00:00	QQQ	ETF	171.32	171.41	171.13	171.18	31391.0
2018-12-04 07:00:00	QQQ	ETF	171.17	171.24	170.93	171.13	46818.0
2018-12-04 08:00:00	QQQ	ETF	171.12	171.7	170.33	171.58	229052.0
2018-12-04 09:00:00	QQQ	ETF	171.58	171.8048	170.93	171.33	4079678.0
2018-12-04 10:00:00	QQQ	ETF	171.34	171.91	171.17	171.3	5257464.0
2018-12-04 11:00:00	QQQ	ETF	171.29	171.47	170.48	170.5	3928635.0
2018-12-04 12:00:00	QQQ	ETF	170.49	170.49	167.3	167.9	12100702.0
2018-12-04 13:00:00	QQQ	ETF	167.88	168.2	166.0204	167.26	8051622.0
2018-12-04 14:00:00	QQQ	ETF	167.25	168.14	166.91	167.34	6956616.0
2018-12-04 15:00:00	QQQ	ETF	167.34	167.34	165.52	165.82	15832211.0
2018-12-04 16:00:00	QQQ	ETF	165.82	166.12	165.43	165.82	5128352.0
2018-12-04 17:00:00	QQQ	ETF	165.89	165.94	165.6	165.66	149524.0
2018-12-04 18:00:00	QQQ	ETF	165.66	166.32	165.6	166.31	98813.0
2018-12-04 19:00:00	QQQ	ETF	166.38	166.67	166.2	166.33	171768.0
2018-12-04 04:00:00	IWM	ETF	153.22	153.22	153.0	153.07	1600.0
2018-12-04 05:00:00	IWM	ETF	153.02	153.5	153.02	153.48	12100.0
2018-12-04 06:00:00	IWM	ETF	153.82	153.82	153.57	153.6	4800.0
2018-12-04 07:00:00	IWM	ETF	153.52	153.75	153.5	153.75	17400.0
2018-12-04 08:00:00	IWM	ETF	154.08	154.08	153.12	153.97	23362.0
2018-12-04 09:00:00	IWM	ETF	153.83	154.13	152.74	152.9	1604026.0
2018-12-04 10:00:00	IWM	ETF	152.908	152.96	151.8601	151.88	2535439.0
2018-12-04 11:00:00	IWM	ETF	151.8659	152.11	150.85	150.865	2918538.0
2018-12-04 12:00:00	IWM	ETF	150.87	150.98	148.8125	149.09	5665053.0
2018-12-04 13:00:00	IWM	ETF	149.05	149.24	147.84	148.95	4073547.0
2018-12-04 14:00:00	IWM	ETF	148.95	149.36	148.5	148.5	4519204.0
2018-12-04 15:00:00	IWM	ETF	148.5	148.51	147.14	147.56	11209867.0
2018-12-04 16:00:00	IWM	ETF	147.55	147.8	147.27	147.69	3427798.0
2018-12-04 17:00:00	IWM	ETF	147.7	147.75	147.52	147.56	62052.0
2018-12-04 18:00:00	IWM	ETF	147.56	147.99	147.51	147.99	18365.0
2018-12-04 19:00:00	IWM	ETF	148.01	148.23	147.84	147.94	18780.0
2018-12-04 05:00:00	DIA	ETF	257.51	257.51	257.51	257.51	100.0
2018-12-04 06:00:00	DIA	ETF	257.65	257.65	257.36	257.36	200.0

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

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