PREVIEW / etf_1hour / 2018-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-19.parquet
  size:    302 KB
  rows:    9,934

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-03-19 04:00:00	SPY	ETF	273.78	273.78	272.18	272.7	62864.0
2018-03-19 05:00:00	SPY	ETF	272.58	273.16	272.58	273.1	75894.0
2018-03-19 06:00:00	SPY	ETF	273.14	273.14	272.91	272.95	48223.0
2018-03-19 07:00:00	SPY	ETF	272.98	273.02	272.68	273.0	194671.0
2018-03-19 08:00:00	SPY	ETF	273.0	274.2	272.7	273.13	649674.0
2018-03-19 09:00:00	SPY	ETF	273.15	274.3957	272.27	272.7	8766136.0
2018-03-19 10:00:00	SPY	ETF	272.71	272.78	271.44	271.6	8958317.0
2018-03-19 11:00:00	SPY	ETF	271.6	271.795	270.17	270.4	10918906.0
2018-03-19 12:00:00	SPY	ETF	270.4	270.69	269.67	270.13	10829907.0
2018-03-19 13:00:00	SPY	ETF	270.135	270.23	268.81	269.85	17646285.0
2018-03-19 14:00:00	SPY	ETF	269.85	270.145	268.62	269.58	12730257.0
2018-03-19 15:00:00	SPY	ETF	269.58	270.79	269.05	270.49	24227394.0
2018-03-19 16:00:00	SPY	ETF	270.49	271.32	270.49	271.13	11599403.0
2018-03-19 17:00:00	SPY	ETF	271.12	271.22	270.49	270.94	456813.0
2018-03-19 18:00:00	SPY	ETF	270.98	271.02	270.67	270.79	339737.0
2018-03-19 19:00:00	SPY	ETF	270.88	270.9	270.6	270.74	192574.0
2018-03-19 04:00:00	QQQ	ETF	169.72	169.78	168.27	168.7	74450.0
2018-03-19 05:00:00	QQQ	ETF	168.68	168.99	168.59	168.91	27368.0
2018-03-19 06:00:00	QQQ	ETF	169.01	169.01	168.51	168.64	56456.0
2018-03-19 07:00:00	QQQ	ETF	168.64	168.91	168.46	168.87	520411.0
2018-03-19 08:00:00	QQQ	ETF	168.83	169.25	168.51	169.05	256780.0
2018-03-19 09:00:00	QQQ	ETF	169.04	169.23	168.471	168.85	7301453.0
2018-03-19 10:00:00	QQQ	ETF	168.84	168.96	167.61	167.74	8318941.0
2018-03-19 11:00:00	QQQ	ETF	167.73	167.8	166.1	166.25	7534198.0
2018-03-19 12:00:00	QQQ	ETF	166.24	166.87	165.96	166.57	6692253.0
2018-03-19 13:00:00	QQQ	ETF	166.54	166.63	165.75	166.38	6500688.0
2018-03-19 14:00:00	QQQ	ETF	166.38	166.71	165.6393	166.3775	5764593.0
2018-03-19 15:00:00	QQQ	ETF	166.39	167.23	166.09	167.15	7929890.0
2018-03-19 16:00:00	QQQ	ETF	167.16	168.0	167.1	167.85	5030066.0
2018-03-19 17:00:00	QQQ	ETF	167.85	167.89	167.55	167.7	77756.0
2018-03-19 18:00:00	QQQ	ETF	167.71	167.71	167.38	167.48	79010.0
2018-03-19 19:00:00	QQQ	ETF	167.52	167.52	167.07	167.12	100400.0
2018-03-19 04:00:00	IWM	ETF	157.0	157.0	156.59	156.59	4300.0
2018-03-19 05:00:00	IWM	ETF	156.75	156.75	156.75	156.75	100.0
2018-03-19 06:00:00	IWM	ETF	156.75	156.75	156.65	156.73	9139.0
2018-03-19 07:00:00	IWM	ETF	156.73	156.75	156.57	156.75	24690.0
2018-03-19 08:00:00	IWM	ETF	156.75	157.08	156.74	156.98	37007.0
2018-03-19 09:00:00	IWM	ETF	157.0	157.2099	156.57	157.0441	1440135.0
2018-03-19 10:00:00	IWM	ETF	157.04	157.04	155.86	156.065	3257432.0
2018-03-19 11:00:00	IWM	ETF	156.07	156.15	155.37	155.49	2329020.0
2018-03-19 12:00:00	IWM	ETF	155.49	155.86	155.0353	155.28	1990017.0
2018-03-19 13:00:00	IWM	ETF	155.27	155.47	154.45	155.43	2216270.0
2018-03-19 14:00:00	IWM	ETF	155.42	155.65	154.94	155.5	2401149.0
2018-03-19 15:00:00	IWM	ETF	155.49	156.51	155.3	156.3	5641837.0
2018-03-19 16:00:00	IWM	ETF	156.28	156.64	156.28	156.58	1486511.0
2018-03-19 17:00:00	IWM	ETF	156.54	156.54	156.4	156.4	589.0
2018-03-19 18:00:00	IWM	ETF	156.42	156.42	156.28	156.33	11328.0
2018-03-19 19:00:00	IWM	ETF	156.29	156.3	156.17	156.29	5950.0
2018-03-19 04:00:00	DIA	ETF	248.71	248.73	247.45	247.55	1789.0
2018-03-19 07:00:00	DIA	ETF	248.05	248.05	247.81	247.94	983.0

> showing 50 of 9,934 rows — these rows as CSV

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