PREVIEW / etf_1hour / 2019-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-18.parquet
  size:    319 KB
  rows:    10,705

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
2019-03-18 04:00:00	SPY	ETF	281.71	281.81	281.58	281.72	17688.0
2019-03-18 05:00:00	SPY	ETF	281.67	281.71	281.43	281.52	19204.0
2019-03-18 06:00:00	SPY	ETF	281.54	281.67	281.4	281.58	13432.0
2019-03-18 07:00:00	SPY	ETF	281.56	281.98	281.56	281.9	90015.0
2019-03-18 08:00:00	SPY	ETF	281.74	281.92	281.56	281.63	230795.0
2019-03-18 09:00:00	SPY	ETF	281.65	282.43	281.5	282.42	7396870.0
2019-03-18 10:00:00	SPY	ETF	282.425	282.66	282.08	282.5	7425312.0
2019-03-18 11:00:00	SPY	ETF	282.5	282.55	281.3	281.59	7705677.0
2019-03-18 12:00:00	SPY	ETF	281.61	282.03	281.4301	281.9321	5764672.0
2019-03-18 13:00:00	SPY	ETF	281.93	282.18	281.82	282.11	3392526.0
2019-03-18 14:00:00	SPY	ETF	282.1	282.29	281.94	282.155	3666171.0
2019-03-18 15:00:00	SPY	ETF	282.16	282.56	281.84	282.39	17902201.0
2019-03-18 16:00:00	SPY	ETF	282.39	282.7	282.3049	282.65	7238324.0
2019-03-18 17:00:00	SPY	ETF	282.66	282.68	282.33	282.61	322192.0
2019-03-18 18:00:00	SPY	ETF	282.62	282.83	282.61	282.67	109944.0
2019-03-18 19:00:00	SPY	ETF	282.66	282.75	282.58	282.68	34048.0
2019-03-18 04:00:00	QQQ	ETF	178.34	178.43	178.27	178.37	4438.0
2019-03-18 05:00:00	QQQ	ETF	178.36	178.4	178.22	178.28	34760.0
2019-03-18 06:00:00	QQQ	ETF	178.27	178.3	178.13	178.22	22213.0
2019-03-18 07:00:00	QQQ	ETF	178.24	178.45	178.21	178.35	43524.0
2019-03-18 08:00:00	QQQ	ETF	178.33	178.45	178.08	178.09	123192.0
2019-03-18 09:00:00	QQQ	ETF	178.08	178.74	177.89	178.74	3209309.0
2019-03-18 10:00:00	QQQ	ETF	178.74	178.99	178.48	178.85	4311672.0
2019-03-18 11:00:00	QQQ	ETF	178.85	178.87	177.72	177.91	4010402.0
2019-03-18 12:00:00	QQQ	ETF	177.92	178.11	177.5915	178.01	3234250.0
2019-03-18 13:00:00	QQQ	ETF	178.01	178.27	177.97	178.26	1495578.0
2019-03-18 14:00:00	QQQ	ETF	178.2532	178.5	178.21	178.46	3138152.0
2019-03-18 15:00:00	QQQ	ETF	178.46	178.53	178.21	178.41	5062271.0
2019-03-18 16:00:00	QQQ	ETF	178.4	178.62	178.3	178.58	1854828.0
2019-03-18 17:00:00	QQQ	ETF	178.61	178.66	178.45	178.56	25440.0
2019-03-18 18:00:00	QQQ	ETF	178.6	178.7	178.56	178.58	24193.0
2019-03-18 19:00:00	QQQ	ETF	178.56	178.65	178.55	178.6	27118.0
2019-03-18 05:00:00	IWM	ETF	154.95	154.95	154.81	154.89	11095.0
2019-03-18 06:00:00	IWM	ETF	154.9	154.9	154.78	154.87	731.0
2019-03-18 07:00:00	IWM	ETF	155.06	155.2	155.06	155.12	6444.0
2019-03-18 08:00:00	IWM	ETF	155.12	155.18	155.01	155.09	264673.0
2019-03-18 09:00:00	IWM	ETF	155.0	155.92	155.0	155.92	2321612.0
2019-03-18 10:00:00	IWM	ETF	155.92	156.45	155.69	156.38	3206700.0
2019-03-18 11:00:00	IWM	ETF	156.37	156.4	154.48	154.99	3042627.0
2019-03-18 12:00:00	IWM	ETF	155.0	155.31	154.62	155.24	1430619.0
2019-03-18 13:00:00	IWM	ETF	155.24	155.56	155.16	155.39	1122987.0
2019-03-18 14:00:00	IWM	ETF	155.38	155.51	155.33	155.44	857623.0
2019-03-18 15:00:00	IWM	ETF	155.45	155.89	155.265	155.76	2397210.0
2019-03-18 16:00:00	IWM	ETF	155.76	155.93	155.75	155.88	2568251.0
2019-03-18 17:00:00	IWM	ETF	155.92	155.98	155.9	155.98	11210.0
2019-03-18 18:00:00	IWM	ETF	155.97	156.01	155.95	155.95	21000.0
2019-03-18 19:00:00	IWM	ETF	155.95	155.97	155.9	155.94	8160.0
2019-03-18 05:00:00	DIA	ETF	258.06	258.06	258.06	258.06	6000.0
2019-03-18 06:00:00	DIA	ETF	258.1	258.15	257.68	257.68	10400.0
2019-03-18 07:00:00	DIA	ETF	258.21	258.25	258.2	258.2	6855.0

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

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