PREVIEW / etf_1hour / 2018-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-30.parquet
  size:    322 KB
  rows:    10,579

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-01-30 04:00:00	SPY	ETF	283.68	283.84	283.31	283.79	16074.0
2018-01-30 05:00:00	SPY	ETF	283.89	283.89	283.42	283.47	124756.0
2018-01-30 06:00:00	SPY	ETF	283.4	283.61	283.34	283.41	133671.0
2018-01-30 07:00:00	SPY	ETF	283.45	283.5	282.91	283.32	252433.0
2018-01-30 08:00:00	SPY	ETF	283.32	283.62	282.81	282.87	1622975.0
2018-01-30 09:00:00	SPY	ETF	282.85	283.29	281.92	281.99	22060620.0
2018-01-30 10:00:00	SPY	ETF	281.99	282.8464	281.22	282.721	21961640.0
2018-01-30 11:00:00	SPY	ETF	282.73	284.736	281.9	281.96	17103783.0
2018-01-30 12:00:00	SPY	ETF	281.97	282.22	281.64	281.89	9974824.0
2018-01-30 13:00:00	SPY	ETF	281.88	282.36	281.37	282.13	10085333.0
2018-01-30 14:00:00	SPY	ETF	282.13	282.52	281.52	281.64	10789411.0
2018-01-30 15:00:00	SPY	ETF	281.64	282.45	281.53	281.66	20615256.0
2018-01-30 16:00:00	SPY	ETF	281.65	282.5	281.45	281.65	12558497.0
2018-01-30 17:00:00	SPY	ETF	281.65	281.76	281.5	281.59	3190943.0
2018-01-30 18:00:00	SPY	ETF	281.63	281.9	281.56	281.76	174263.0
2018-01-30 19:00:00	SPY	ETF	281.76	282.06	281.7	281.72	108041.0
2018-01-30 04:00:00	QQQ	ETF	169.42	169.42	169.25	169.39	12804.0
2018-01-30 05:00:00	QQQ	ETF	169.46	169.46	169.21	169.21	31221.0
2018-01-30 06:00:00	QQQ	ETF	169.22	169.36	169.2	169.21	47361.0
2018-01-30 07:00:00	QQQ	ETF	169.23	169.42	169.07	169.21	446055.0
2018-01-30 08:00:00	QQQ	ETF	169.23	169.34	168.77	168.78	760657.0
2018-01-30 09:00:00	QQQ	ETF	168.78	168.97	168.09	168.21	6659561.0
2018-01-30 10:00:00	QQQ	ETF	168.2	169.12	167.82	169.07	7168341.0
2018-01-30 11:00:00	QQQ	ETF	169.08	169.42	168.66	168.715	4672072.0
2018-01-30 12:00:00	QQQ	ETF	168.72	168.93	168.37	168.56	2731150.0
2018-01-30 13:00:00	QQQ	ETF	168.558	168.9	168.13	168.786	2823806.0
2018-01-30 14:00:00	QQQ	ETF	168.79	169.07	168.39	168.46	3205917.0
2018-01-30 15:00:00	QQQ	ETF	168.46	169.1	168.385	168.74	5300008.0
2018-01-30 16:00:00	QQQ	ETF	168.71	168.96	168.6	168.7	952085.0
2018-01-30 17:00:00	QQQ	ETF	168.67	168.78	168.67	168.7	6447.0
2018-01-30 18:00:00	QQQ	ETF	168.7	168.93	168.65	168.75	54092.0
2018-01-30 19:00:00	QQQ	ETF	168.89	168.94	168.69	168.69	47036.0
2018-01-30 04:00:00	IWM	ETF	157.78	157.97	157.78	157.83	15300.0
2018-01-30 05:00:00	IWM	ETF	157.75	157.77	157.67	157.7	4102.0
2018-01-30 06:00:00	IWM	ETF	157.68	157.8	157.61	157.61	6452.0
2018-01-30 07:00:00	IWM	ETF	157.61	157.8	157.53	157.8	136917.0
2018-01-30 08:00:00	IWM	ETF	157.71	158.1	157.59	157.59	139331.0
2018-01-30 09:00:00	IWM	ETF	157.6	158.12	157.1	157.45	2855371.0
2018-01-30 10:00:00	IWM	ETF	157.45	158.17	157.02	158.07	3876265.0
2018-01-30 11:00:00	IWM	ETF	158.07	158.22	157.421	157.465	2550902.0
2018-01-30 12:00:00	IWM	ETF	157.48	157.55	157.09	157.23	1637598.0
2018-01-30 13:00:00	IWM	ETF	157.22	157.62	156.73	157.5	2027152.0
2018-01-30 14:00:00	IWM	ETF	157.5	157.6	157.06	157.245	1983447.0
2018-01-30 15:00:00	IWM	ETF	157.23	157.67	157.16	157.19	3540156.0
2018-01-30 16:00:00	IWM	ETF	157.19	157.44	157.17	157.29	2709667.0
2018-01-30 17:00:00	IWM	ETF	157.29	157.3	157.2	157.3	1500.0
2018-01-30 18:00:00	IWM	ETF	157.34	157.46	157.34	157.46	5688.0
2018-01-30 19:00:00	IWM	ETF	157.41	157.6	157.32	157.32	2474.0
2018-01-30 04:00:00	DIA	ETF	263.6	263.6	262.95	262.95	500.0
2018-01-30 05:00:00	DIA	ETF	262.72	262.72	262.66	262.7	2276.0

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

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