PREVIEW / etf_1hour / 2019-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-20.parquet
  size:    323 KB
  rows:    10,682

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-20 04:00:00	SPY	ETF	282.43	282.76	282.33	282.73	15210.0
2019-03-20 05:00:00	SPY	ETF	282.67	282.67	282.36	282.36	14305.0
2019-03-20 06:00:00	SPY	ETF	282.4	282.44	281.98	282.03	69994.0
2019-03-20 07:00:00	SPY	ETF	282.06	282.25	281.89	282.24	76277.0
2019-03-20 08:00:00	SPY	ETF	282.29	282.45	281.87	281.88	284913.0
2019-03-20 09:00:00	SPY	ETF	281.86	282.2327	281.21	281.3	6755347.0
2019-03-20 10:00:00	SPY	ETF	281.3	281.795	281.08	281.625	7102087.0
2019-03-20 11:00:00	SPY	ETF	281.63	281.85	280.6501	280.7596	6732205.0
2019-03-20 12:00:00	SPY	ETF	280.76	281.22	280.32	280.91	7635687.0
2019-03-20 13:00:00	SPY	ETF	280.9	281.2989	280.79	281.24	4011486.0
2019-03-20 14:00:00	SPY	ETF	281.24	283.5	281.24	283.14	21558859.0
2019-03-20 15:00:00	SPY	ETF	283.16	283.36	281.42	281.53	21749559.0
2019-03-20 16:00:00	SPY	ETF	281.52	281.55	280.85	280.92	6894726.0
2019-03-20 17:00:00	SPY	ETF	280.97	281.04	280.9	281.01	174713.0
2019-03-20 18:00:00	SPY	ETF	280.99	281.25	280.9	281.14	133839.0
2019-03-20 19:00:00	SPY	ETF	281.17	281.49	281.16	281.4	53120.0
2019-03-20 04:00:00	QQQ	ETF	179.08	179.29	179.06	179.25	6524.0
2019-03-20 05:00:00	QQQ	ETF	179.17	179.22	179.01	179.07	15857.0
2019-03-20 06:00:00	QQQ	ETF	179.07	179.12	178.88	178.91	12551.0
2019-03-20 07:00:00	QQQ	ETF	178.92	179.06	178.74	179.06	69429.0
2019-03-20 08:00:00	QQQ	ETF	178.89	179.17	178.67	178.84	75188.0
2019-03-20 09:00:00	QQQ	ETF	178.88	179.11	178.49	178.66	3436279.0
2019-03-20 10:00:00	QQQ	ETF	178.66	179.22	178.63	179.14	5175633.0
2019-03-20 11:00:00	QQQ	ETF	179.15	179.25	178.41	178.4856	2986762.0
2019-03-20 12:00:00	QQQ	ETF	178.49	178.92	178.24	178.7299	3612127.0
2019-03-20 13:00:00	QQQ	ETF	178.72	178.94	178.57	178.87	2347717.0
2019-03-20 14:00:00	QQQ	ETF	178.9	180.86	178.9	180.525	9914710.0
2019-03-20 15:00:00	QQQ	ETF	180.54	180.68	179.52	179.79	8347413.0
2019-03-20 16:00:00	QQQ	ETF	179.79	179.85	179.41	179.46	1761387.0
2019-03-20 17:00:00	QQQ	ETF	179.57	179.6	179.4345	179.6	35419.0
2019-03-20 18:00:00	QQQ	ETF	179.49	179.76	179.49	179.71	61630.0
2019-03-20 19:00:00	QQQ	ETF	179.71	179.92	179.71	179.9	68556.0
2019-03-20 05:00:00	IWM	ETF	154.53	154.59	154.5	154.5	4680.0
2019-03-20 06:00:00	IWM	ETF	154.52	154.52	154.38	154.38	54146.0
2019-03-20 07:00:00	IWM	ETF	154.31	154.48	154.3	154.48	31276.0
2019-03-20 08:00:00	IWM	ETF	154.3	154.58	154.3	154.31	123997.0
2019-03-20 09:00:00	IWM	ETF	154.37	154.58	153.86	153.9	2310459.0
2019-03-20 10:00:00	IWM	ETF	153.905	154.075	153.41	153.61	3083430.0
2019-03-20 11:00:00	IWM	ETF	153.62	153.775	152.4753	152.63	1863242.0
2019-03-20 12:00:00	IWM	ETF	152.64	153.06	152.41	153.0267	2551428.0
2019-03-20 13:00:00	IWM	ETF	153.01	153.96	152.93	153.9	1657977.0
2019-03-20 14:00:00	IWM	ETF	153.9	155.42	153.84	154.95	6398012.0
2019-03-20 15:00:00	IWM	ETF	154.95	155.4	153.25	153.29	5931134.0
2019-03-20 16:00:00	IWM	ETF	153.29	153.3295	152.92	153.0	727057.0
2019-03-20 17:00:00	IWM	ETF	153.06	153.1	152.99	153.07	15983.0
2019-03-20 18:00:00	IWM	ETF	153.05	153.11	152.95	153.11	12885.0
2019-03-20 19:00:00	IWM	ETF	153.15	153.32	153.13	153.25	24100.0
2019-03-20 05:00:00	DIA	ETF	258.94	258.94	258.94	258.94	100.0
2019-03-20 06:00:00	DIA	ETF	258.36	258.36	258.34	258.34	1500.0
2019-03-20 07:00:00	DIA	ETF	258.46	258.51	258.35	258.51	2500.0

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

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