PREVIEW / etf_1hour / 2019-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-15.parquet
  size:    317 KB
  rows:    10,651

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-01-15 04:00:00	SPY	ETF	258.42	258.42	257.89	257.9	19088.0
2019-01-15 05:00:00	SPY	ETF	258.04	258.34	257.9	258.3	11589.0
2019-01-15 06:00:00	SPY	ETF	258.21	258.54	257.49	257.65	93242.0
2019-01-15 07:00:00	SPY	ETF	257.66	257.82	257.5	257.72	249301.0
2019-01-15 08:00:00	SPY	ETF	257.68	259.22	257.41	257.7	424009.0
2019-01-15 09:00:00	SPY	ETF	257.69	259.4	257.6	259.13	8046757.0
2019-01-15 10:00:00	SPY	ETF	259.14	260.04	258.62	259.53	16371869.0
2019-01-15 11:00:00	SPY	ETF	259.53	260.28	259.105	260.16	8551187.0
2019-01-15 12:00:00	SPY	ETF	260.16	260.7	259.895	260.08	7816744.0
2019-01-15 13:00:00	SPY	ETF	260.09	260.29	259.8515	260.1388	4708140.0
2019-01-15 14:00:00	SPY	ETF	260.13	260.45	258.72	259.6985	11541176.0
2019-01-15 15:00:00	SPY	ETF	259.7	260.58	259.5834	260.38	16260947.0
2019-01-15 16:00:00	SPY	ETF	260.38	260.4084	259.75	259.95	9477972.0
2019-01-15 17:00:00	SPY	ETF	259.98	260.09	259.9	259.96	131635.0
2019-01-15 18:00:00	SPY	ETF	259.91	260.5	259.85	260.43	159855.0
2019-01-15 19:00:00	SPY	ETF	260.37	260.43	259.91	260.11	91702.0
2019-01-15 04:00:00	QQQ	ETF	160.0	160.01	159.65	159.66	9476.0
2019-01-15 05:00:00	QQQ	ETF	159.74	160.01	159.69	160.0	9122.0
2019-01-15 06:00:00	QQQ	ETF	159.99	160.16	159.6	159.72	35724.0
2019-01-15 07:00:00	QQQ	ETF	159.7	159.85	159.59	159.84	94098.0
2019-01-15 08:00:00	QQQ	ETF	159.57	160.59	159.57	159.77	209500.0
2019-01-15 09:00:00	QQQ	ETF	159.8	161.66	159.74	161.565	5755197.0
2019-01-15 10:00:00	QQQ	ETF	161.57	162.15	161.24	161.66	7542077.0
2019-01-15 11:00:00	QQQ	ETF	161.66	162.31	161.39	162.26	3863542.0
2019-01-15 12:00:00	QQQ	ETF	162.27	162.6	162.16	162.26	3322004.0
2019-01-15 13:00:00	QQQ	ETF	162.26	162.5	162.19	162.35	2086000.0
2019-01-15 14:00:00	QQQ	ETF	162.34	162.54	161.16	161.8944	4829140.0
2019-01-15 15:00:00	QQQ	ETF	161.89	162.48	161.82	162.43	6947539.0
2019-01-15 16:00:00	QQQ	ETF	162.42	162.49	162.2	162.35	2778263.0
2019-01-15 17:00:00	QQQ	ETF	162.27	162.48	162.27	162.29	30421.0
2019-01-15 18:00:00	QQQ	ETF	162.27	162.66	162.27	162.62	69936.0
2019-01-15 19:00:00	QQQ	ETF	162.63	162.63	162.15	162.38	58544.0
2019-01-15 05:00:00	IWM	ETF	142.77	142.9	142.77	142.9	2200.0
2019-01-15 06:00:00	IWM	ETF	142.94	142.97	142.5	142.53	7100.0
2019-01-15 07:00:00	IWM	ETF	142.55	142.62	142.43	142.54	49148.0
2019-01-15 08:00:00	IWM	ETF	142.56	142.71	142.25	142.57	27245.0
2019-01-15 09:00:00	IWM	ETF	142.61	143.11	142.34	142.52	2143873.0
2019-01-15 10:00:00	IWM	ETF	142.52	143.16	142.0901	143.14	4125332.0
2019-01-15 11:00:00	IWM	ETF	143.13	143.25	142.59	143.11	2256692.0
2019-01-15 12:00:00	IWM	ETF	143.13	143.45	142.76	142.8991	1498956.0
2019-01-15 13:00:00	IWM	ETF	142.9	143.52	142.84	143.44	1654067.0
2019-01-15 14:00:00	IWM	ETF	143.43	143.64	142.64	143.3444	2109298.0
2019-01-15 15:00:00	IWM	ETF	143.34	143.6481	143.27	143.53	4544021.0
2019-01-15 16:00:00	IWM	ETF	143.54	143.6452	142.8889	143.15	1931153.0
2019-01-15 17:00:00	IWM	ETF	143.08	143.3	143.08	143.3	2747.0
2019-01-15 18:00:00	IWM	ETF	143.35	143.44	143.3	143.41	9000.0
2019-01-15 19:00:00	IWM	ETF	143.41	143.41	143.16	143.33	9750.0
2019-01-15 04:00:00	DIA	ETF	239.9	239.9	239.88	239.88	285.0
2019-01-15 06:00:00	DIA	ETF	240.02	240.02	239.5	239.5	1100.0
2019-01-15 07:00:00	DIA	ETF	239.01	239.09	238.88	239.03	1801.0

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

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