PREVIEW / etf_1hour / 2018-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-26.parquet
  size:    300 KB
  rows:    9,935

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-07-26 04:00:00	SPY	ETF	283.02	283.07	282.89	282.96	16899.0
2018-07-26 05:00:00	SPY	ETF	282.96	283.23	282.96	283.18	24308.0
2018-07-26 06:00:00	SPY	ETF	283.15	283.18	282.93	282.99	124786.0
2018-07-26 07:00:00	SPY	ETF	283.0	283.19	282.98	283.1	298437.0
2018-07-26 08:00:00	SPY	ETF	283.1001	283.34	282.85	283.04	803862.0
2018-07-26 09:00:00	SPY	ETF	283.02	283.84	282.9534	283.42	8760247.0
2018-07-26 10:00:00	SPY	ETF	283.42	283.84	283.32	283.8251	6673974.0
2018-07-26 11:00:00	SPY	ETF	283.83	283.96	283.54	283.91	4266241.0
2018-07-26 12:00:00	SPY	ETF	283.92	284.11	283.19	283.26	5253357.0
2018-07-26 13:00:00	SPY	ETF	283.26	283.66	283.1415	283.4	4791863.0
2018-07-26 14:00:00	SPY	ETF	283.39	283.62	283.245	283.38	4320996.0
2018-07-26 15:00:00	SPY	ETF	283.39	283.49	283.12	283.29	11974695.0
2018-07-26 16:00:00	SPY	ETF	283.29	283.77	282.82	283.47	9395757.0
2018-07-26 17:00:00	SPY	ETF	283.45	283.64	283.34	283.52	126760.0
2018-07-26 18:00:00	SPY	ETF	283.51	283.64	283.43	283.55	47999.0
2018-07-26 19:00:00	SPY	ETF	283.6	283.73	283.2745	283.73	60787.0
2018-07-26 04:00:00	QQQ	ETF	180.15	180.15	179.83	179.96	36028.0
2018-07-26 05:00:00	QQQ	ETF	179.89	180.18	179.79	180.11	65057.0
2018-07-26 06:00:00	QQQ	ETF	180.11	180.14	179.96	180.0	58288.0
2018-07-26 07:00:00	QQQ	ETF	180.02	180.4	180.0	180.3	168568.0
2018-07-26 08:00:00	QQQ	ETF	180.14	180.57	179.8	180.12	693779.0
2018-07-26 09:00:00	QQQ	ETF	180.13	180.86	179.81	180.21	7471307.0
2018-07-26 10:00:00	QQQ	ETF	180.205	180.795	180.14	180.6	6104151.0
2018-07-26 11:00:00	QQQ	ETF	180.605	180.9	180.4555	180.87	3105854.0
2018-07-26 12:00:00	QQQ	ETF	180.87	180.92	180.01	180.1439	2093068.0
2018-07-26 13:00:00	QQQ	ETF	180.14	180.44	180.0262	180.27	2068250.0
2018-07-26 14:00:00	QQQ	ETF	180.2667	180.41	180.11	180.12	1797295.0
2018-07-26 15:00:00	QQQ	ETF	180.12	180.31	179.97	180.16	6042413.0
2018-07-26 16:00:00	QQQ	ETF	180.16	181.1	178.64	180.56	3592655.0
2018-07-26 17:00:00	QQQ	ETF	180.35	180.81	180.35	180.61	222444.0
2018-07-26 18:00:00	QQQ	ETF	180.68	180.75	180.59	180.65	44089.0
2018-07-26 19:00:00	QQQ	ETF	180.66	180.76	180.62	180.76	20491.0
2018-07-26 04:00:00	IWM	ETF	167.55	167.55	167.55	167.55	500.0
2018-07-26 05:00:00	IWM	ETF	167.6	167.64	167.6	167.6	800.0
2018-07-26 06:00:00	IWM	ETF	167.59	167.59	167.53	167.53	5500.0
2018-07-26 07:00:00	IWM	ETF	167.49	167.58	167.47	167.51	18251.0
2018-07-26 08:00:00	IWM	ETF	167.57	167.7	167.48	167.6	57380.0
2018-07-26 09:00:00	IWM	ETF	167.69	168.32	167.51	168.175	2628986.0
2018-07-26 10:00:00	IWM	ETF	168.18	169.08	168.105	168.93	3376173.0
2018-07-26 11:00:00	IWM	ETF	168.93	169.365	168.6	168.8	2275487.0
2018-07-26 12:00:00	IWM	ETF	168.81	168.855	167.91	167.9475	1912292.0
2018-07-26 13:00:00	IWM	ETF	167.9485	168.34	167.8701	168.25	1059067.0
2018-07-26 14:00:00	IWM	ETF	168.24	168.54	168.17	168.345	913599.0
2018-07-26 15:00:00	IWM	ETF	168.34	168.58	168.27	168.36	3185924.0
2018-07-26 16:00:00	IWM	ETF	168.36	168.77	167.3811	168.4	2670533.0
2018-07-26 17:00:00	IWM	ETF	168.4	168.48	168.4	168.48	1183.0
2018-07-26 18:00:00	IWM	ETF	168.46	168.62	168.41	168.53	19432.0
2018-07-26 19:00:00	IWM	ETF	168.49	168.64	168.49	168.62	2036.0
2018-07-26 05:00:00	DIA	ETF	254.24	254.29	254.24	254.29	1200.0
2018-07-26 06:00:00	DIA	ETF	254.52	254.52	254.18	254.18	800.0

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

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