PREVIEW / etf_1hour / 2019-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-13.parquet
  size:    319 KB
  rows:    10,539

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-13 04:00:00	SPY	ETF	279.27	279.63	279.27	279.58	6650.0
2019-03-13 05:00:00	SPY	ETF	279.6	279.71	279.55	279.55	3300.0
2019-03-13 06:00:00	SPY	ETF	279.61	279.92	279.61	279.92	30028.0
2019-03-13 07:00:00	SPY	ETF	279.87	280.1	279.84	280.08	96202.0
2019-03-13 08:00:00	SPY	ETF	280.0199	280.32	278.9	280.05	329524.0
2019-03-13 09:00:00	SPY	ETF	280.05	280.94	280.03	280.83	6549499.0
2019-03-13 10:00:00	SPY	ETF	280.82	281.43	280.8	281.33	8920589.0
2019-03-13 11:00:00	SPY	ETF	281.34	282.1	281.33	281.81	13324827.0
2019-03-13 12:00:00	SPY	ETF	281.8115	282.0	281.49	281.81	8480536.0
2019-03-13 13:00:00	SPY	ETF	281.82	282.02	281.7	282.02	4402832.0
2019-03-13 14:00:00	SPY	ETF	282.03	282.38	281.11	281.65	10592766.0
2019-03-13 15:00:00	SPY	ETF	281.62	281.74	281.13	281.34	14164985.0
2019-03-13 16:00:00	SPY	ETF	281.33	281.83	281.2511	281.79	12206941.0
2019-03-13 17:00:00	SPY	ETF	281.78	281.87	281.72	281.82	95036.0
2019-03-13 18:00:00	SPY	ETF	281.8	282.07	281.67	282.0	369097.0
2019-03-13 19:00:00	SPY	ETF	281.95	281.95	281.59	281.73	112406.0
2019-03-13 04:00:00	QQQ	ETF	175.67	175.95	175.67	175.94	8771.0
2019-03-13 05:00:00	QQQ	ETF	175.97	176.04	175.86	175.86	19140.0
2019-03-13 06:00:00	QQQ	ETF	175.91	176.08	175.91	176.06	27100.0
2019-03-13 07:00:00	QQQ	ETF	176.06	176.39	176.02	176.39	65385.0
2019-03-13 08:00:00	QQQ	ETF	176.28	176.61	175.55	176.26	205541.0
2019-03-13 09:00:00	QQQ	ETF	176.27	176.97	176.25	176.7675	2676334.0
2019-03-13 10:00:00	QQQ	ETF	176.77	177.16	176.53	177.1	3801992.0
2019-03-13 11:00:00	QQQ	ETF	177.1	177.68	177.09	177.4401	4719560.0
2019-03-13 12:00:00	QQQ	ETF	177.45	177.6	177.26	177.4081	2035779.0
2019-03-13 13:00:00	QQQ	ETF	177.41	177.71	177.34	177.7059	2159854.0
2019-03-13 14:00:00	QQQ	ETF	177.71	177.93	177.08	177.44	4549157.0
2019-03-13 15:00:00	QQQ	ETF	177.44	177.51	176.89	177.02	6129697.0
2019-03-13 16:00:00	QQQ	ETF	177.02	177.4	176.95	177.35	1094714.0
2019-03-13 17:00:00	QQQ	ETF	177.24	177.39	177.24	177.37	25787.0
2019-03-13 18:00:00	QQQ	ETF	177.37	177.63	177.26	177.56	109757.0
2019-03-13 19:00:00	QQQ	ETF	177.54	177.54	177.23	177.3	79762.0
2019-03-13 05:00:00	IWM	ETF	154.37	154.37	154.37	154.37	1000.0
2019-03-13 06:00:00	IWM	ETF	154.37	154.4	154.37	154.38	2000.0
2019-03-13 07:00:00	IWM	ETF	154.46	154.69	154.46	154.69	21561.0
2019-03-13 08:00:00	IWM	ETF	154.73	154.79	154.64	154.65	13400.0
2019-03-13 09:00:00	IWM	ETF	154.65	155.36	154.65	155.19	1600680.0
2019-03-13 10:00:00	IWM	ETF	155.19	155.52	155.1	155.48	2222785.0
2019-03-13 11:00:00	IWM	ETF	155.48	155.73	155.37	155.49	2024559.0
2019-03-13 12:00:00	IWM	ETF	155.5	155.6199	155.19	155.45	1324002.0
2019-03-13 13:00:00	IWM	ETF	155.4419	155.52	155.31	155.41	1145869.0
2019-03-13 14:00:00	IWM	ETF	155.41	155.48	154.85	155.16	2330596.0
2019-03-13 15:00:00	IWM	ETF	155.15	155.21	154.87	154.98	3538652.0
2019-03-13 16:00:00	IWM	ETF	154.98	155.25	154.9289	155.25	3305057.0
2019-03-13 17:00:00	IWM	ETF	155.25	155.28	155.06	155.23	42484.0
2019-03-13 18:00:00	IWM	ETF	155.18	155.33	154.98	155.33	16204.0
2019-03-13 19:00:00	IWM	ETF	155.25	155.25	155.13	155.16	10102.0
2019-03-13 07:00:00	DIA	ETF	255.97	256.05	255.97	256.05	10260.0
2019-03-13 08:00:00	DIA	ETF	256.01	256.61	255.23	256.55	12973.0
2019-03-13 09:00:00	DIA	ETF	256.57	257.18	256.57	257.1382	407554.0

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

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