PREVIEW / etf_1hour / 2019-03-19

all etf 1-hour files

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

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-19 04:00:00	SPY	ETF	282.76	283.27	282.76	283.27	4336.0
2019-03-19 05:00:00	SPY	ETF	283.27	283.45	283.22	283.36	30505.0
2019-03-19 06:00:00	SPY	ETF	283.33	283.79	283.33	283.79	14235.0
2019-03-19 07:00:00	SPY	ETF	283.72	283.75	283.46	283.5	88722.0
2019-03-19 08:00:00	SPY	ETF	283.648	283.71	282.83	283.61	300013.0
2019-03-19 09:00:00	SPY	ETF	283.63	283.76	283.15	283.17	6115803.0
2019-03-19 10:00:00	SPY	ETF	283.175	283.79	282.98	283.01	8564299.0
2019-03-19 11:00:00	SPY	ETF	283.01	284.23	283.01	284.17	6632363.0
2019-03-19 12:00:00	SPY	ETF	284.17	284.36	282.63	283.56	13674113.0
2019-03-19 13:00:00	SPY	ETF	283.57	283.68	283.11	283.15	6709758.0
2019-03-19 14:00:00	SPY	ETF	283.15	283.39	282.735	282.87	5087469.0
2019-03-19 15:00:00	SPY	ETF	282.88	283.1	281.41	282.48	28304870.0
2019-03-19 16:00:00	SPY	ETF	282.49	283.16	281.9793	282.25	12954881.0
2019-03-19 17:00:00	SPY	ETF	282.23	282.4	282.17	282.19	390936.0
2019-03-19 18:00:00	SPY	ETF	282.2	282.36	281.95	281.95	146315.0
2019-03-19 19:00:00	SPY	ETF	281.95	282.09	281.85	282.04	36199.0
2019-03-19 04:00:00	QQQ	ETF	178.74	178.95	178.74	178.94	6400.0
2019-03-19 05:00:00	QQQ	ETF	178.93	179.1	178.9	179.05	24302.0
2019-03-19 06:00:00	QQQ	ETF	179.07	179.3	179.04	179.26	17775.0
2019-03-19 07:00:00	QQQ	ETF	179.25	179.27	179.12	179.18	81781.0
2019-03-19 08:00:00	QQQ	ETF	179.25	179.36	178.69	179.26	139532.0
2019-03-19 09:00:00	QQQ	ETF	179.26	179.47	178.92	179.07	2731528.0
2019-03-19 10:00:00	QQQ	ETF	179.06	179.47	178.87	178.8921	3796301.0
2019-03-19 11:00:00	QQQ	ETF	178.9	179.77	178.9	179.76	3322429.0
2019-03-19 12:00:00	QQQ	ETF	179.77	180.0	178.89	179.49	6202829.0
2019-03-19 13:00:00	QQQ	ETF	179.49	179.66	179.3233	179.4169	2987470.0
2019-03-19 14:00:00	QQQ	ETF	179.4	179.63	179.22	179.33	2449145.0
2019-03-19 15:00:00	QQQ	ETF	179.34	179.41	178.29	179.04	7110195.0
2019-03-19 16:00:00	QQQ	ETF	179.06	179.07	178.77	178.94	1212672.0
2019-03-19 17:00:00	QQQ	ETF	179.0	179.0	178.82	178.87	11071.0
2019-03-19 18:00:00	QQQ	ETF	178.88	179.05	178.74	178.78	38886.0
2019-03-19 19:00:00	QQQ	ETF	178.73	178.86	178.69	178.81	13581.0
2019-03-19 05:00:00	IWM	ETF	156.28	156.41	156.28	156.41	400.0
2019-03-19 06:00:00	IWM	ETF	156.38	156.56	156.38	156.56	1700.0
2019-03-19 07:00:00	IWM	ETF	156.66	156.67	156.55	156.58	30200.0
2019-03-19 08:00:00	IWM	ETF	156.59	156.63	156.5	156.53	27214.0
2019-03-19 09:00:00	IWM	ETF	156.55	156.55	155.7701	155.88	1764023.0
2019-03-19 10:00:00	IWM	ETF	155.87	156.19	155.25	155.27	2135576.0
2019-03-19 11:00:00	IWM	ETF	155.27	155.87	155.27	155.84	1610759.0
2019-03-19 12:00:00	IWM	ETF	155.84	156.32	155.3	155.74	3094536.0
2019-03-19 13:00:00	IWM	ETF	155.75	155.88	155.54	155.5695	1140510.0
2019-03-19 14:00:00	IWM	ETF	155.56	155.68	155.26	155.395	1589916.0
2019-03-19 15:00:00	IWM	ETF	155.39	155.49	154.57	154.95	3724109.0
2019-03-19 16:00:00	IWM	ETF	154.96	154.96	154.46	154.88	499281.0
2019-03-19 17:00:00	IWM	ETF	154.82	154.82	154.81	154.81	500.0
2019-03-19 18:00:00	IWM	ETF	154.86	154.96	154.7	154.71	10967.0
2019-03-19 19:00:00	IWM	ETF	154.65	154.74	154.6	154.71	9440.0
2019-03-19 04:00:00	DIA	ETF	259.61	259.83	259.61	259.83	2800.0
2019-03-19 05:00:00	DIA	ETF	259.82	260.02	259.82	260.02	1400.0
2019-03-19 06:00:00	DIA	ETF	259.94	260.32	259.94	260.32	2490.0

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

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