PREVIEW / etf_1hour / 2018-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-20.parquet
  size:    290 KB
  rows:    9,583

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-20 04:00:00	SPY	ETF	271.21	271.26	270.97	271.26	49400.0
2018-03-20 05:00:00	SPY	ETF	271.21	271.21	270.61	270.87	53075.0
2018-03-20 06:00:00	SPY	ETF	270.77	271.47	270.76	271.39	38155.0
2018-03-20 07:00:00	SPY	ETF	271.38	271.78	271.33	271.78	195992.0
2018-03-20 08:00:00	SPY	ETF	271.45	271.84	271.3	271.36	734342.0
2018-03-20 09:00:00	SPY	ETF	271.34	271.67	270.83	270.95	5910708.0
2018-03-20 10:00:00	SPY	ETF	270.9401	271.66	270.54	271.27	7291764.0
2018-03-20 11:00:00	SPY	ETF	271.29	271.39	270.23	270.63	5055228.0
2018-03-20 12:00:00	SPY	ETF	270.655	271.23	270.47	270.8	5595301.0
2018-03-20 13:00:00	SPY	ETF	270.8	270.95	270.24	270.3899	9644455.0
2018-03-20 14:00:00	SPY	ETF	270.39	271.35	270.18	271.26	5228331.0
2018-03-20 15:00:00	SPY	ETF	271.24	271.58	270.78	270.94	12620676.0
2018-03-20 16:00:00	SPY	ETF	270.93	271.35	270.86	271.25	5757658.0
2018-03-20 17:00:00	SPY	ETF	271.22	271.25	270.95	271.21	405720.0
2018-03-20 18:00:00	SPY	ETF	271.22	271.39	271.0	271.02	142538.0
2018-03-20 19:00:00	SPY	ETF	271.02	271.23	271.02	271.17	152555.0
2018-03-20 04:00:00	QQQ	ETF	167.41	167.48	167.3	167.43	62700.0
2018-03-20 05:00:00	QQQ	ETF	167.42	167.42	166.95	167.15	50804.0
2018-03-20 06:00:00	QQQ	ETF	167.17	167.7	167.17	167.7	25349.0
2018-03-20 07:00:00	QQQ	ETF	167.65	168.2	167.65	168.12	206279.0
2018-03-20 08:00:00	QQQ	ETF	168.1	168.14	167.74	167.81	325731.0
2018-03-20 09:00:00	QQQ	ETF	167.82	167.97	167.0	167.43	5496401.0
2018-03-20 10:00:00	QQQ	ETF	167.45	167.92	166.95	167.75	5013887.0
2018-03-20 11:00:00	QQQ	ETF	167.76	167.8498	166.61	166.985	3619540.0
2018-03-20 12:00:00	QQQ	ETF	166.99	167.833	166.84	167.4115	2743660.0
2018-03-20 13:00:00	QQQ	ETF	167.41	167.5	166.88	166.99	2495556.0
2018-03-20 14:00:00	QQQ	ETF	167.0	167.77	166.88	167.73	2548532.0
2018-03-20 15:00:00	QQQ	ETF	167.73	168.04	167.46	167.64	5254408.0
2018-03-20 16:00:00	QQQ	ETF	167.62	167.95	167.443	167.92	937931.0
2018-03-20 17:00:00	QQQ	ETF	167.88	167.88	167.65	167.78	114914.0
2018-03-20 18:00:00	QQQ	ETF	167.83	167.97	167.65	167.7	31794.0
2018-03-20 19:00:00	QQQ	ETF	167.7	167.82	167.7	167.82	22589.0
2018-03-20 04:00:00	IWM	ETF	156.66	156.67	156.56	156.63	8500.0
2018-03-20 05:00:00	IWM	ETF	156.43	156.52	156.35	156.5	7288.0
2018-03-20 06:00:00	IWM	ETF	156.49	156.8	156.49	156.79	22077.0
2018-03-20 07:00:00	IWM	ETF	156.74	157.04	156.73	157.04	45738.0
2018-03-20 08:00:00	IWM	ETF	157.02	157.02	156.76	156.83	49454.0
2018-03-20 09:00:00	IWM	ETF	156.78	157.02	156.46	156.51	1740896.0
2018-03-20 10:00:00	IWM	ETF	156.53	156.93	156.25	156.52	1674620.0
2018-03-20 11:00:00	IWM	ETF	156.52	156.63	155.99	156.21	1283144.0
2018-03-20 12:00:00	IWM	ETF	156.205	156.56	156.09	156.2	1138354.0
2018-03-20 13:00:00	IWM	ETF	156.19	156.37	155.84	155.87	693587.0
2018-03-20 14:00:00	IWM	ETF	155.87	156.65	155.77	156.54	1409085.0
2018-03-20 15:00:00	IWM	ETF	156.53	156.71	156.21	156.27	2245262.0
2018-03-20 16:00:00	IWM	ETF	156.25	156.56	156.13	156.44	493420.0
2018-03-20 17:00:00	IWM	ETF	156.33	156.33	156.32	156.32	1100.0
2018-03-20 18:00:00	IWM	ETF	156.5	156.5	156.28	156.28	3553.0
2018-03-20 19:00:00	IWM	ETF	156.32	156.37	156.32	156.36	4225.0
2018-03-20 05:00:00	DIA	ETF	246.01	246.01	246.01	246.01	200.0
2018-03-20 07:00:00	DIA	ETF	246.62	246.88	246.62	246.88	778.0

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

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