PREVIEW / etf_1hour / 2019-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-15.parquet
  size:    324 KB
  rows:    10,652

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-05-15 04:00:00	SPY	ETF	283.41	283.75	283.21	283.62	6328.0
2019-05-15 05:00:00	SPY	ETF	283.7	283.84	282.87	282.95	33194.0
2019-05-15 06:00:00	SPY	ETF	282.92	283.13	282.57	283.05	53293.0
2019-05-15 07:00:00	SPY	ETF	283.0	283.2	282.65	282.68	206165.0
2019-05-15 08:00:00	SPY	ETF	283.0799	284.49	281.54	281.85	1077762.0
2019-05-15 09:00:00	SPY	ETF	281.83	282.48	281.3	282.27	8493461.0
2019-05-15 10:00:00	SPY	ETF	282.27	284.51	281.77	284.2485	15082935.0
2019-05-15 11:00:00	SPY	ETF	284.25	285.28	283.84	285.16	8350475.0
2019-05-15 12:00:00	SPY	ETF	285.16	285.56	284.7	284.89	5899135.0
2019-05-15 13:00:00	SPY	ETF	284.89	285.5	284.7101	285.44	4094971.0
2019-05-15 14:00:00	SPY	ETF	285.43	285.76	285.26	285.3	5544792.0
2019-05-15 15:00:00	SPY	ETF	285.29	285.77	284.97	285.06	15058276.0
2019-05-15 16:00:00	SPY	ETF	285.06	285.46	282.0005	285.24	8361727.0
2019-05-15 17:00:00	SPY	ETF	285.27	285.29	285.06	285.15	173227.0
2019-05-15 18:00:00	SPY	ETF	285.17	285.18	284.9	285.06	149810.0
2019-05-15 19:00:00	SPY	ETF	285.06	285.06	284.89	284.97	42349.0
2019-05-15 04:00:00	QQQ	ETF	180.72	180.96	180.5	180.94	62668.0
2019-05-15 05:00:00	QQQ	ETF	180.75	181.07	180.33	180.36	23402.0
2019-05-15 06:00:00	QQQ	ETF	180.37	180.56	180.05	180.28	148501.0
2019-05-15 07:00:00	QQQ	ETF	180.34	180.52	180.05	180.09	136214.0
2019-05-15 08:00:00	QQQ	ETF	180.43	181.36	179.23	179.49	587508.0
2019-05-15 09:00:00	QQQ	ETF	179.48	180.48	179.06	180.4	5305485.0
2019-05-15 10:00:00	QQQ	ETF	180.39	182.37	180.35	182.13	8307408.0
2019-05-15 11:00:00	QQQ	ETF	182.13	182.955	181.795	182.74	4771965.0
2019-05-15 12:00:00	QQQ	ETF	182.75	183.1368	182.32	182.44	3906157.0
2019-05-15 13:00:00	QQQ	ETF	182.44	183.34	182.385	183.25	2674591.0
2019-05-15 14:00:00	QQQ	ETF	183.26	183.55	183.12	183.19	2404113.0
2019-05-15 15:00:00	QQQ	ETF	183.18	183.5	182.95	183.03	5405138.0
2019-05-15 16:00:00	QQQ	ETF	183.03	183.47	182.94	183.3	1806431.0
2019-05-15 17:00:00	QQQ	ETF	183.37	183.37	183.09	183.22	520497.0
2019-05-15 18:00:00	QQQ	ETF	183.21	183.27	183.06	183.17	44714.0
2019-05-15 19:00:00	QQQ	ETF	183.15	183.15	183.03	183.06	25110.0
2019-05-15 04:00:00	IWM	ETF	153.66	153.66	153.66	153.66	200.0
2019-05-15 05:00:00	IWM	ETF	153.37	153.37	153.37	153.37	500.0
2019-05-15 06:00:00	IWM	ETF	153.27	153.31	153.26	153.29	39600.0
2019-05-15 07:00:00	IWM	ETF	153.3	153.34	153.09	153.09	7100.0
2019-05-15 08:00:00	IWM	ETF	153.11	153.8	152.46	152.67	164895.0
2019-05-15 09:00:00	IWM	ETF	152.63	152.9	152.0699	152.8485	2463178.0
2019-05-15 10:00:00	IWM	ETF	152.84	153.78	152.23	153.57	4202139.0
2019-05-15 11:00:00	IWM	ETF	153.58	154.1098	153.17	154.08	1420675.0
2019-05-15 12:00:00	IWM	ETF	154.09	154.41	153.51	153.65	962199.0
2019-05-15 13:00:00	IWM	ETF	153.64	154.048	153.42	154.01	1477521.0
2019-05-15 14:00:00	IWM	ETF	154.01	154.25	153.96	154.06	1406570.0
2019-05-15 15:00:00	IWM	ETF	154.05	154.35	153.94	154.06	2747678.0
2019-05-15 16:00:00	IWM	ETF	154.05	154.33	154.04	154.21	881158.0
2019-05-15 17:00:00	IWM	ETF	154.21	154.21	154.04	154.1	45099.0
2019-05-15 18:00:00	IWM	ETF	154.14	154.14	154.06	154.06	7375.0
2019-05-15 19:00:00	IWM	ETF	154.04	154.05	154.04	154.04	4549.0
2019-05-15 07:00:00	DIA	ETF	255.62	255.62	255.35	255.35	3328.0
2019-05-15 08:00:00	DIA	ETF	255.54	255.54	254.27	254.43	28031.0

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

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