PREVIEW / etf_1hour / 2019-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-14.parquet
  size:    308 KB
  rows:    10,236

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-14 04:00:00	SPY	ETF	281.59	282.18	281.59	282.18	12157.0
2019-03-14 05:00:00	SPY	ETF	282.22	282.3	282.03	282.21	19418.0
2019-03-14 06:00:00	SPY	ETF	282.2	282.2	280.89	281.18	250782.0
2019-03-14 07:00:00	SPY	ETF	281.12	281.56	281.12	281.56	179675.0
2019-03-14 08:00:00	SPY	ETF	281.58	281.95	281.15	281.8	555405.0
2019-03-14 09:00:00	SPY	ETF	281.81	281.84	281.07	281.39	5824695.0
2019-03-14 10:00:00	SPY	ETF	281.38	281.44	280.6662	281.22	8926449.0
2019-03-14 11:00:00	SPY	ETF	281.2266	281.84	281.01	281.66	8960540.0
2019-03-14 12:00:00	SPY	ETF	281.66	281.77	281.31	281.42	10312861.0
2019-03-14 13:00:00	SPY	ETF	281.42	281.44	280.94	281.04	4457456.0
2019-03-14 14:00:00	SPY	ETF	281.04	281.25	280.88	281.1425	6716744.0
2019-03-14 15:00:00	SPY	ETF	281.15	281.5	281.08	281.19	10949374.0
2019-03-14 16:00:00	SPY	ETF	281.19	281.4875	280.95	281.06	8855893.0
2019-03-14 17:00:00	SPY	ETF	281.05	281.16	280.97	281.07	611247.0
2019-03-14 18:00:00	SPY	ETF	281.07	281.26	281.05	281.17	102027.0
2019-03-14 19:00:00	SPY	ETF	281.22	281.23	281.06	281.23	37719.0
2019-03-14 04:00:00	QQQ	ETF	177.46	177.79	177.46	177.79	25500.0
2019-03-14 05:00:00	QQQ	ETF	177.79	177.88	177.67	177.78	15120.0
2019-03-14 06:00:00	QQQ	ETF	177.75	177.75	177.01	177.1	52550.0
2019-03-14 07:00:00	QQQ	ETF	177.18	177.4	177.08	177.37	138897.0
2019-03-14 08:00:00	QQQ	ETF	177.4	177.63	176.82	177.43	261449.0
2019-03-14 09:00:00	QQQ	ETF	177.41	177.43	176.72	177.15	2430679.0
2019-03-14 10:00:00	QQQ	ETF	177.15	177.18	176.66	176.905	3294986.0
2019-03-14 11:00:00	QQQ	ETF	176.9	177.25	176.7516	177.18	2506960.0
2019-03-14 12:00:00	QQQ	ETF	177.17	177.34	176.96	177.0701	1750800.0
2019-03-14 13:00:00	QQQ	ETF	177.08	177.14	176.83	176.875	1660305.0
2019-03-14 14:00:00	QQQ	ETF	176.88	177.03	176.75	176.865	1792793.0
2019-03-14 15:00:00	QQQ	ETF	176.87	177.02	176.68	176.72	3950473.0
2019-03-14 16:00:00	QQQ	ETF	176.72	176.9523	176.57	176.68	1287116.0
2019-03-14 17:00:00	QQQ	ETF	176.73	176.75	176.63	176.63	9364.0
2019-03-14 18:00:00	QQQ	ETF	176.69	176.87	176.69	176.77	58184.0
2019-03-14 19:00:00	QQQ	ETF	176.77	176.84	176.71	176.84	12564.0
2019-03-14 04:00:00	IWM	ETF	154.75	155.25	154.75	155.25	1700.0
2019-03-14 05:00:00	IWM	ETF	155.39	155.39	155.39	155.39	1000.0
2019-03-14 06:00:00	IWM	ETF	155.19	155.23	155.19	155.21	900.0
2019-03-14 07:00:00	IWM	ETF	154.98	155.04	154.98	155.04	47669.0
2019-03-14 08:00:00	IWM	ETF	155.04	155.27	154.82	155.18	48281.0
2019-03-14 09:00:00	IWM	ETF	155.21	155.21	154.71	154.85	1182782.0
2019-03-14 10:00:00	IWM	ETF	154.85	154.9	154.2	154.63	1966365.0
2019-03-14 11:00:00	IWM	ETF	154.64	154.85	154.28	154.785	1099848.0
2019-03-14 12:00:00	IWM	ETF	154.78	155.02	154.68	154.74	994129.0
2019-03-14 13:00:00	IWM	ETF	154.75	154.8184	154.24	154.375	1134274.0
2019-03-14 14:00:00	IWM	ETF	154.37	154.51	154.23	154.34	1277971.0
2019-03-14 15:00:00	IWM	ETF	154.35	154.67	154.24	154.33	3209385.0
2019-03-14 16:00:00	IWM	ETF	154.35	154.3672	154.07	154.22	798591.0
2019-03-14 17:00:00	IWM	ETF	154.29	154.35	154.13	154.28	29911.0
2019-03-14 18:00:00	IWM	ETF	154.25	154.35	154.24	154.29	17063.0
2019-03-14 19:00:00	IWM	ETF	154.34	154.35	154.25	154.35	2900.0
2019-03-14 06:00:00	DIA	ETF	257.66	257.66	257.08	257.08	3500.0
2019-03-14 07:00:00	DIA	ETF	257.24	257.35	257.09	257.3	8800.0

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

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