PREVIEW / etf_1hour / 2020-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-08.parquet
  size:    363 KB
  rows:    12,510

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-08 04:00:00	SPY	ETF	314.61	315.33	314.28	314.34	39966.0
2020-07-08 05:00:00	SPY	ETF	314.45	314.45	313.1	313.46	126751.0
2020-07-08 06:00:00	SPY	ETF	313.32	314.09	313.14	314.09	69540.0
2020-07-08 07:00:00	SPY	ETF	314.07	314.675	313.8	314.41	200664.0
2020-07-08 08:00:00	SPY	ETF	314.49	314.67	313.72	314.24	418870.0
2020-07-08 09:00:00	SPY	ETF	314.21	316.19	313.94	316.0987	5834994.0
2020-07-08 10:00:00	SPY	ETF	316.1	316.3	315.04	315.39	6122421.0
2020-07-08 11:00:00	SPY	ETF	315.38	315.47	312.7	314.14	9873593.0
2020-07-08 12:00:00	SPY	ETF	314.14	314.94	313.99	314.915	4895628.0
2020-07-08 13:00:00	SPY	ETF	314.9101	314.95	313.58	313.86	4403741.0
2020-07-08 14:00:00	SPY	ETF	313.86	314.71	313.6	314.57	4843013.0
2020-07-08 15:00:00	SPY	ETF	314.575	316.17	314.525	316.12	12880511.0
2020-07-08 16:00:00	SPY	ETF	316.11	316.71	315.94	316.57	3499192.0
2020-07-08 17:00:00	SPY	ETF	316.56	316.68	316.51	316.59	112256.0
2020-07-08 18:00:00	SPY	ETF	316.62	316.91	316.6	316.68	156201.0
2020-07-08 19:00:00	SPY	ETF	316.68	317.05	316.59	316.85	277013.0
2020-07-08 04:00:00	QQQ	ETF	257.68	258.17	257.42	257.75	46542.0
2020-07-08 05:00:00	QQQ	ETF	257.72	257.75	256.82	257.07	42653.0
2020-07-08 06:00:00	QQQ	ETF	257.04	257.66	256.97	257.63	32884.0
2020-07-08 07:00:00	QQQ	ETF	257.57	258.21	257.57	258.11	116960.0
2020-07-08 08:00:00	QQQ	ETF	258.18	258.23	256.57	257.87	216486.0
2020-07-08 09:00:00	QQQ	ETF	257.85	259.36	257.62	259.3	3211795.0
2020-07-08 10:00:00	QQQ	ETF	259.299	259.62	258.6005	259.32	3058735.0
2020-07-08 11:00:00	QQQ	ETF	259.33	259.3879	256.5	258.3501	4624935.0
2020-07-08 12:00:00	QQQ	ETF	258.37	259.25	258.18	259.25	2537802.0
2020-07-08 13:00:00	QQQ	ETF	259.24	259.28	257.88	258.1	2419734.0
2020-07-08 14:00:00	QQQ	ETF	258.12	258.74	257.67	258.64	2977766.0
2020-07-08 15:00:00	QQQ	ETF	258.64	260.02	258.6	259.94	4759216.0
2020-07-08 16:00:00	QQQ	ETF	259.93	260.39	259.6479	260.38	879113.0
2020-07-08 17:00:00	QQQ	ETF	260.38	260.51	260.3	260.41	40075.0
2020-07-08 18:00:00	QQQ	ETF	260.49	260.74	260.27	260.41	126692.0
2020-07-08 19:00:00	QQQ	ETF	260.44	260.69	260.26	260.58	96213.0
2020-07-08 04:00:00	IWM	ETF	141.0	141.45	140.75	140.94	19918.0
2020-07-08 05:00:00	IWM	ETF	140.9	140.9	140.16	140.41	23764.0
2020-07-08 06:00:00	IWM	ETF	140.29	140.45	140.0	140.45	26385.0
2020-07-08 07:00:00	IWM	ETF	140.51	141.0	140.5	140.8	41508.0
2020-07-08 08:00:00	IWM	ETF	140.3804	141.04	139.8	140.58	92777.0
2020-07-08 09:00:00	IWM	ETF	140.65	142.09	140.13	141.98	3335172.0
2020-07-08 10:00:00	IWM	ETF	142.01	142.5	140.7	140.9	3477203.0
2020-07-08 11:00:00	IWM	ETF	140.9	140.97	139.1	140.6	4428589.0
2020-07-08 12:00:00	IWM	ETF	140.6	141.02	140.49	140.95	1543896.0
2020-07-08 13:00:00	IWM	ETF	140.95	140.95	140.2608	140.5	1302816.0
2020-07-08 14:00:00	IWM	ETF	140.5	140.99	140.16	140.57	2095747.0
2020-07-08 15:00:00	IWM	ETF	140.57	141.98	140.52	141.95	3634874.0
2020-07-08 16:00:00	IWM	ETF	141.94	142.05	141.62	142.04	1036807.0
2020-07-08 17:00:00	IWM	ETF	141.92	142.01	141.86	141.94	1910.0
2020-07-08 18:00:00	IWM	ETF	142.24	142.24	141.94	142.01	20983.0
2020-07-08 19:00:00	IWM	ETF	142.01	142.2	142.0	142.07	27590.0
2020-07-08 04:00:00	DIA	ETF	259.54	259.56	259.32	259.32	3016.0
2020-07-08 05:00:00	DIA	ETF	258.7	258.7	258.36	258.6	2100.0

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

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