PREVIEW / etf_1hour / 2020-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-14.parquet
  size:    366 KB
  rows:    12,685

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
2020-07-14 04:00:00	SPY	ETF	314.91	316.25	314.9	315.93	39064.0
2020-07-14 05:00:00	SPY	ETF	315.93	316.3	315.5	315.96	33124.0
2020-07-14 06:00:00	SPY	ETF	315.96	316.12	315.54	316.06	216400.0
2020-07-14 07:00:00	SPY	ETF	316.18	316.48	315.55	316.2	357515.0
2020-07-14 08:00:00	SPY	ETF	315.9804	316.5	313.71	313.77	1057032.0
2020-07-14 09:00:00	SPY	ETF	313.77	315.31	312.0	313.89	11921976.0
2020-07-14 10:00:00	SPY	ETF	313.84	315.92	312.33	314.82	13449862.0
2020-07-14 11:00:00	SPY	ETF	314.875	316.67	314.3	316.0	9167367.0
2020-07-14 12:00:00	SPY	ETF	316.0	316.64	315.15	315.31	5926870.0
2020-07-14 13:00:00	SPY	ETF	315.32	316.99	314.52	316.34	7718715.0
2020-07-14 14:00:00	SPY	ETF	316.34	317.67	315.9	317.4	9232082.0
2020-07-14 15:00:00	SPY	ETF	317.42	319.76	315.77	318.89	23309187.0
2020-07-14 16:00:00	SPY	ETF	318.9	319.0966	318.25	318.52	7930672.0
2020-07-14 17:00:00	SPY	ETF	318.52	321.85	318.52	320.59	1511362.0
2020-07-14 18:00:00	SPY	ETF	320.55	321.56	320.45	321.28	544525.0
2020-07-14 19:00:00	SPY	ETF	321.28	321.41	320.62	321.04	207156.0
2020-07-14 04:00:00	QQQ	ETF	258.58	259.84	258.57	259.52	56789.0
2020-07-14 05:00:00	QQQ	ETF	259.47	259.75	259.0	259.36	60026.0
2020-07-14 06:00:00	QQQ	ETF	259.43	259.47	258.74	258.91	97392.0
2020-07-14 07:00:00	QQQ	ETF	258.96	260.42	258.45	260.08	426972.0
2020-07-14 08:00:00	QQQ	ETF	260.05	260.95	256.29	256.46	1304162.0
2020-07-14 09:00:00	QQQ	ETF	256.51	259.36	253.43	255.59	13956980.0
2020-07-14 10:00:00	QQQ	ETF	255.54	257.92	252.76	256.27	13111220.0
2020-07-14 11:00:00	QQQ	ETF	256.265	258.66	255.31	257.66	6523573.0
2020-07-14 12:00:00	QQQ	ETF	257.65	258.82	256.62	256.86	3574409.0
2020-07-14 13:00:00	QQQ	ETF	256.88	259.18	255.92	258.3799	4887475.0
2020-07-14 14:00:00	QQQ	ETF	258.39	259.49	257.99	258.86	4840873.0
2020-07-14 15:00:00	QQQ	ETF	258.89	260.79	256.82	260.41	9565332.0
2020-07-14 16:00:00	QQQ	ETF	260.41	260.4857	258.88	259.72	3306566.0
2020-07-14 17:00:00	QQQ	ETF	259.66	261.91	259.59	261.49	361774.0
2020-07-14 18:00:00	QQQ	ETF	261.49	262.02	261.05	261.48	186020.0
2020-07-14 19:00:00	QQQ	ETF	261.51	261.51	261.27	261.47	155572.0
2020-07-14 04:00:00	IWM	ETF	139.71	140.63	139.71	140.63	1000.0
2020-07-14 05:00:00	IWM	ETF	140.4	140.76	140.4	140.61	4936.0
2020-07-14 06:00:00	IWM	ETF	140.63	140.72	140.5	140.68	16200.0
2020-07-14 07:00:00	IWM	ETF	140.89	141.11	140.42	140.78	84486.0
2020-07-14 08:00:00	IWM	ETF	140.8999	140.9	139.34	139.41	234913.0
2020-07-14 09:00:00	IWM	ETF	139.39	140.5	138.85	140.13	4349919.0
2020-07-14 10:00:00	IWM	ETF	140.09	141.1	138.64	140.41	5028203.0
2020-07-14 11:00:00	IWM	ETF	140.41	141.35	140.1322	140.89	2994519.0
2020-07-14 12:00:00	IWM	ETF	140.875	141.12	140.22	140.33	1673753.0
2020-07-14 13:00:00	IWM	ETF	140.3874	140.93	140.01	140.68	1927186.0
2020-07-14 14:00:00	IWM	ETF	140.68	141.22	140.51	141.0	2024115.0
2020-07-14 15:00:00	IWM	ETF	141.005	141.98	140.155	141.89	4250634.0
2020-07-14 16:00:00	IWM	ETF	141.89	142.007	141.32	141.42	781810.0
2020-07-14 17:00:00	IWM	ETF	141.51	144.0	141.51	143.34	460254.0
2020-07-14 18:00:00	IWM	ETF	143.21	144.32	141.83	144.04	148646.0
2020-07-14 19:00:00	IWM	ETF	144.1	144.13	143.6	143.8	41249.0
2020-07-14 04:00:00	DIA	ETF	261.0	262.25	261.0	262.07	2275.0
2020-07-14 05:00:00	DIA	ETF	262.07	262.29	261.91	261.91	1426.0

> showing 50 of 12,685 rows — these rows as CSV

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