PREVIEW / etf_1hour / 2018-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-10.parquet
  size:    305 KB
  rows:    10,042

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-08-10 04:00:00	SPY	ETF	284.02	284.09	283.68	283.78	73056.0
2018-08-10 05:00:00	SPY	ETF	283.75	284.08	283.4	283.49	38938.0
2018-08-10 06:00:00	SPY	ETF	283.56	283.98	283.48	283.95	39692.0
2018-08-10 07:00:00	SPY	ETF	283.95	284.0	283.75	283.77	209027.0
2018-08-10 08:00:00	SPY	ETF	283.77	284.1	283.5	283.69	1064967.0
2018-08-10 09:00:00	SPY	ETF	283.69	283.91	283.17	283.25	10373083.0
2018-08-10 10:00:00	SPY	ETF	283.24	283.72	282.96	283.67	10308499.0
2018-08-10 11:00:00	SPY	ETF	283.67	284.055	283.4	283.705	7647490.0
2018-08-10 12:00:00	SPY	ETF	283.7	283.76	283.41	283.56	4586192.0
2018-08-10 13:00:00	SPY	ETF	283.56	283.59	282.72	282.77	7189963.0
2018-08-10 14:00:00	SPY	ETF	282.77	283.04	282.39	282.639	7981994.0
2018-08-10 15:00:00	SPY	ETF	282.635	283.6	282.36	283.12	15906351.0
2018-08-10 16:00:00	SPY	ETF	283.12	283.67	282.6684	283.66	10419093.0
2018-08-10 17:00:00	SPY	ETF	283.67	283.67	283.16	283.61	145487.0
2018-08-10 18:00:00	SPY	ETF	283.61	283.74	283.42	283.7	156265.0
2018-08-10 19:00:00	SPY	ETF	283.71	283.73	283.67	283.7	28025.0
2018-08-10 04:00:00	QQQ	ETF	181.16	181.16	180.99	181.02	30836.0
2018-08-10 05:00:00	QQQ	ETF	181.02	181.21	180.72	180.75	19680.0
2018-08-10 06:00:00	QQQ	ETF	180.75	181.03	180.69	181.01	30360.0
2018-08-10 07:00:00	QQQ	ETF	181.05	181.07	180.84	180.87	102726.0
2018-08-10 08:00:00	QQQ	ETF	180.85	181.91	180.7	180.86	392335.0
2018-08-10 09:00:00	QQQ	ETF	180.88	181.22	180.55	180.58	4266476.0
2018-08-10 10:00:00	QQQ	ETF	180.57	181.18	180.39	180.8	4972150.0
2018-08-10 11:00:00	QQQ	ETF	180.8	181.13	180.69	180.945	2681995.0
2018-08-10 12:00:00	QQQ	ETF	180.94	181.085	180.74	180.95	1446393.0
2018-08-10 13:00:00	QQQ	ETF	180.95	180.96	180.12	180.21	2845484.0
2018-08-10 14:00:00	QQQ	ETF	180.2	180.37	179.84	180.09	3445318.0
2018-08-10 15:00:00	QQQ	ETF	180.09	180.725	179.94	180.5	5902512.0
2018-08-10 16:00:00	QQQ	ETF	180.5	180.85	180.5	180.85	1763453.0
2018-08-10 17:00:00	QQQ	ETF	180.78	180.79	180.52	180.64	19446.0
2018-08-10 18:00:00	QQQ	ETF	180.68	180.75	180.68	180.75	3103.0
2018-08-10 19:00:00	QQQ	ETF	180.75	180.77	180.7	180.77	4652.0
2018-08-10 04:00:00	IWM	ETF	167.36	167.36	167.08	167.08	7620.0
2018-08-10 05:00:00	IWM	ETF	167.28	167.28	166.93	166.94	7500.0
2018-08-10 06:00:00	IWM	ETF	166.93	167.22	166.93	167.2	9000.0
2018-08-10 07:00:00	IWM	ETF	167.27	167.27	167.14	167.16	24394.0
2018-08-10 08:00:00	IWM	ETF	167.12	167.31	166.99	167.13	76347.0
2018-08-10 09:00:00	IWM	ETF	167.15	167.76	166.91	167.2	2655657.0
2018-08-10 10:00:00	IWM	ETF	167.21	168.26	167.14	168.17	3126883.0
2018-08-10 11:00:00	IWM	ETF	168.185	168.61	167.95	168.49	3240226.0
2018-08-10 12:00:00	IWM	ETF	168.48	168.665	168.24	168.555	1596654.0
2018-08-10 13:00:00	IWM	ETF	168.57	168.6	167.99	168.02	1948853.0
2018-08-10 14:00:00	IWM	ETF	168.0052	168.04	167.59	167.86	1830709.0
2018-08-10 15:00:00	IWM	ETF	167.86	168.115	167.51	167.53	3062065.0
2018-08-10 16:00:00	IWM	ETF	167.6278	167.75	167.5	167.54	939873.0
2018-08-10 17:00:00	IWM	ETF	167.63	167.63	167.5	167.62	3925.0
2018-08-10 18:00:00	IWM	ETF	167.68	167.68	167.63	167.63	300.0
2018-08-10 19:00:00	IWM	ETF	167.67	167.67	167.65	167.65	420.0
2018-08-10 04:00:00	DIA	ETF	254.22	254.22	254.15	254.15	300.0
2018-08-10 07:00:00	DIA	ETF	254.21	254.21	254.1	254.1	1450.0

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

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