PREVIEW / etf_1hour / 2019-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-29.parquet
  size:    318 KB
  rows:    10,610

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-29 04:00:00	SPY	ETF	281.47	281.59	281.23	281.23	11772.0
2019-03-29 05:00:00	SPY	ETF	281.24	281.37	281.22	281.32	2192.0
2019-03-29 06:00:00	SPY	ETF	281.25	281.5	281.03	281.5	27471.0
2019-03-29 07:00:00	SPY	ETF	281.52	282.24	281.48	282.07	350108.0
2019-03-29 08:00:00	SPY	ETF	281.94	282.25	281.33	282.2	463451.0
2019-03-29 09:00:00	SPY	ETF	282.19	282.56	281.62	282.0	6568826.0
2019-03-29 10:00:00	SPY	ETF	282.0	282.219	281.14	281.46	8895839.0
2019-03-29 11:00:00	SPY	ETF	281.45	282.31	281.44	281.88	5838445.0
2019-03-29 12:00:00	SPY	ETF	281.89	282.14	281.44	282.0175	4514047.0
2019-03-29 13:00:00	SPY	ETF	282.02	282.1	281.65	281.95	3882145.0
2019-03-29 14:00:00	SPY	ETF	281.9478	282.69	281.9	282.58	9768440.0
2019-03-29 15:00:00	SPY	ETF	282.59	282.84	282.04	282.62	19691164.0
2019-03-29 16:00:00	SPY	ETF	282.62	282.83	280.7765	282.75	16690405.0
2019-03-29 17:00:00	SPY	ETF	282.74	282.75	282.145	282.47	1372550.0
2019-03-29 18:00:00	SPY	ETF	282.44	282.51	282.4	282.48	73912.0
2019-03-29 19:00:00	SPY	ETF	282.49	282.6	282.49	282.58	23542.0
2019-03-29 04:00:00	QQQ	ETF	179.12	179.22	178.89	178.91	11942.0
2019-03-29 05:00:00	QQQ	ETF	178.84	178.92	178.77	178.88	9100.0
2019-03-29 06:00:00	QQQ	ETF	178.83	178.94	178.64	178.92	27868.0
2019-03-29 07:00:00	QQQ	ETF	178.93	179.39	178.92	179.28	184835.0
2019-03-29 08:00:00	QQQ	ETF	179.28	179.46	178.94	179.4	224274.0
2019-03-29 09:00:00	QQQ	ETF	179.43	179.76	178.9564	179.22	3260574.0
2019-03-29 10:00:00	QQQ	ETF	179.22	179.54	178.59	178.855	3937067.0
2019-03-29 11:00:00	QQQ	ETF	178.84	179.64	178.84	179.28	2841739.0
2019-03-29 12:00:00	QQQ	ETF	179.28	179.47	178.99	179.37	2139681.0
2019-03-29 13:00:00	QQQ	ETF	179.39	179.43	179.13	179.3	1849793.0
2019-03-29 14:00:00	QQQ	ETF	179.3	179.72	179.27	179.67	3090488.0
2019-03-29 15:00:00	QQQ	ETF	179.68	179.83	179.36	179.72	8124871.0
2019-03-29 16:00:00	QQQ	ETF	179.72	180.02	178.3205	179.98	2807193.0
2019-03-29 17:00:00	QQQ	ETF	179.98	179.98	179.455	179.88	207425.0
2019-03-29 18:00:00	QQQ	ETF	179.83	179.93	179.66	179.93	13670.0
2019-03-29 19:00:00	QQQ	ETF	179.9	179.95	179.85	179.88	13798.0
2019-03-29 04:00:00	IWM	ETF	153.02	153.08	153.02	153.08	1000.0
2019-03-29 05:00:00	IWM	ETF	153.0	153.0	153.0	153.0	800.0
2019-03-29 06:00:00	IWM	ETF	152.79	152.91	152.79	152.91	1500.0
2019-03-29 07:00:00	IWM	ETF	153.05	153.51	153.04	153.45	105697.0
2019-03-29 08:00:00	IWM	ETF	153.06	153.6	153.06	153.6	275829.0
2019-03-29 09:00:00	IWM	ETF	153.56	153.83	153.16	153.67	2641704.0
2019-03-29 10:00:00	IWM	ETF	153.67	153.97	153.04	153.1	2655659.0
2019-03-29 11:00:00	IWM	ETF	153.08	153.26	152.71	152.745	2281503.0
2019-03-29 12:00:00	IWM	ETF	152.74	153.035	152.37	153.02	2211769.0
2019-03-29 13:00:00	IWM	ETF	153.02	153.08	152.1	152.76	2484896.0
2019-03-29 14:00:00	IWM	ETF	152.76	153.4	152.7	153.25	1582530.0
2019-03-29 15:00:00	IWM	ETF	153.24	153.39	152.84	153.09	5335280.0
2019-03-29 16:00:00	IWM	ETF	153.1	153.25	152.6409	153.15	1882444.0
2019-03-29 17:00:00	IWM	ETF	153.12	153.12	152.915	153.1	390609.0
2019-03-29 19:00:00	IWM	ETF	153.12	153.21	153.12	153.21	3898.0
2019-03-29 04:00:00	DIA	ETF	257.8	257.8	257.8	257.8	100.0
2019-03-29 06:00:00	DIA	ETF	257.58	257.58	257.58	257.58	1500.0
2019-03-29 07:00:00	DIA	ETF	258.0	258.3	258.0	258.26	8000.0

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

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