PREVIEW / etf_1hour / 2019-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-21.parquet
  size:    324 KB
  rows:    10,573

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-21 04:00:00	SPY	ETF	280.84	281.13	280.75	280.84	3695.0
2019-03-21 05:00:00	SPY	ETF	280.91	281.32	280.91	281.11	56230.0
2019-03-21 06:00:00	SPY	ETF	281.04	281.28	281.0	281.23	64380.0
2019-03-21 07:00:00	SPY	ETF	281.21	281.25	280.02	280.2	700655.0
2019-03-21 08:00:00	SPY	ETF	280.3001	281.5	280.01	280.45	866197.0
2019-03-21 09:00:00	SPY	ETF	280.43	282.42	280.43	282.125	7647718.0
2019-03-21 10:00:00	SPY	ETF	282.13	283.13	282.1	283.12	7540000.0
2019-03-21 11:00:00	SPY	ETF	283.115	284.25	283.11	284.2	9806604.0
2019-03-21 12:00:00	SPY	ETF	284.19	284.2369	283.26	283.54	6647990.0
2019-03-21 13:00:00	SPY	ETF	283.55	284.27	283.54	284.07	7619613.0
2019-03-21 14:00:00	SPY	ETF	284.0701	285.0	284.0701	284.73	11116084.0
2019-03-21 15:00:00	SPY	ETF	284.74	285.18	284.43	284.67	20102703.0
2019-03-21 16:00:00	SPY	ETF	284.67	284.9	284.46	284.6	5603583.0
2019-03-21 17:00:00	SPY	ETF	284.6	284.62	284.44	284.52	124417.0
2019-03-21 18:00:00	SPY	ETF	284.5	284.79	284.49	284.67	109828.0
2019-03-21 19:00:00	SPY	ETF	284.61	284.8	284.55	284.79	37189.0
2019-03-21 04:00:00	QQQ	ETF	179.56	179.84	179.5	179.81	12177.0
2019-03-21 05:00:00	QQQ	ETF	179.71	179.94	179.71	179.84	27593.0
2019-03-21 06:00:00	QQQ	ETF	179.83	180.01	179.78	179.97	35189.0
2019-03-21 07:00:00	QQQ	ETF	179.97	179.97	178.85	179.01	411094.0
2019-03-21 08:00:00	QQQ	ETF	179.75	179.94	178.78	179.09	312464.0
2019-03-21 09:00:00	QQQ	ETF	179.09	180.68	179.08	180.38	4607222.0
2019-03-21 10:00:00	QQQ	ETF	180.38	181.19	180.34	181.1784	5219335.0
2019-03-21 11:00:00	QQQ	ETF	181.18	181.67	181.07	181.65	5373203.0
2019-03-21 12:00:00	QQQ	ETF	181.64	181.69	181.12	181.37	3592601.0
2019-03-21 13:00:00	QQQ	ETF	181.37	181.95	181.37	181.84	3043774.0
2019-03-21 14:00:00	QQQ	ETF	181.84	182.65	181.825	182.535	5534269.0
2019-03-21 15:00:00	QQQ	ETF	182.54	182.83	182.36	182.56	9002408.0
2019-03-21 16:00:00	QQQ	ETF	182.56	182.89	182.43	182.67	2104053.0
2019-03-21 17:00:00	QQQ	ETF	182.72	182.72	182.59	182.59	17174.0
2019-03-21 18:00:00	QQQ	ETF	182.59	182.74	182.55	182.64	32486.0
2019-03-21 19:00:00	QQQ	ETF	182.64	182.78	182.55	182.76	25124.0
2019-03-21 04:00:00	IWM	ETF	152.92	152.92	152.82	152.82	600.0
2019-03-21 05:00:00	IWM	ETF	153.1	153.1	153.05	153.06	4500.0
2019-03-21 06:00:00	IWM	ETF	153.0	153.1	153.0	153.1	2992.0
2019-03-21 07:00:00	IWM	ETF	153.1	153.1	152.52	152.58	75431.0
2019-03-21 08:00:00	IWM	ETF	152.97	152.97	152.5	152.62	192621.0
2019-03-21 09:00:00	IWM	ETF	152.64	154.54	152.64	154.28	3105381.0
2019-03-21 10:00:00	IWM	ETF	154.28	155.12	154.25	155.1	3535943.0
2019-03-21 11:00:00	IWM	ETF	155.0913	156.06	155.07	155.95	3881861.0
2019-03-21 12:00:00	IWM	ETF	155.95	155.97	155.02	155.09	2299933.0
2019-03-21 13:00:00	IWM	ETF	155.1	155.53	154.92	154.95	4682585.0
2019-03-21 14:00:00	IWM	ETF	154.95	155.58	154.94	155.12	3140411.0
2019-03-21 15:00:00	IWM	ETF	155.1299	155.4	154.85	155.28	6016230.0
2019-03-21 16:00:00	IWM	ETF	155.28	155.42	155.14	155.21	923320.0
2019-03-21 17:00:00	IWM	ETF	155.27	155.34	155.22	155.34	49400.0
2019-03-21 18:00:00	IWM	ETF	155.27	155.3	155.21	155.3	5136.0
2019-03-21 19:00:00	IWM	ETF	155.25	155.32	155.22	155.32	8400.0
2019-03-21 04:00:00	DIA	ETF	256.35	256.35	256.35	256.35	200.0
2019-03-21 06:00:00	DIA	ETF	256.72	256.72	256.72	256.72	500.0

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

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