PREVIEW / etf_30min / 2020-07-07

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-07.parquet
  size:    546 KB
  rows:    20,875

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-07 04:00:00	SPY	ETF	315.6	315.77	314.5	314.58	59982.0
2020-07-07 04:30:00	SPY	ETF	314.57	315.0	314.57	314.79	17758.0
2020-07-07 05:00:00	SPY	ETF	314.69	314.79	314.15	314.35	23249.0
2020-07-07 05:30:00	SPY	ETF	314.45	314.57	314.09	314.4	23971.0
2020-07-07 06:00:00	SPY	ETF	314.47	314.54	313.95	314.49	90860.0
2020-07-07 06:30:00	SPY	ETF	314.45	315.0	314.33	314.35	48051.0
2020-07-07 07:00:00	SPY	ETF	314.53	314.959	314.32	314.94	160772.0
2020-07-07 07:30:00	SPY	ETF	314.92	315.46	314.78	315.23	172257.0
2020-07-07 08:00:00	SPY	ETF	315.24	316.9	314.1704	315.03	292686.0
2020-07-07 08:30:00	SPY	ETF	315.03	315.34	314.71	315.32	172702.0
2020-07-07 09:00:00	SPY	ETF	315.3	315.46	315.15	315.36	172549.0
2020-07-07 09:30:00	SPY	ETF	315.38	316.25	314.9	315.99	8699689.0
2020-07-07 10:00:00	SPY	ETF	315.985	317.0496	315.83	316.765	5101278.0
2020-07-07 10:30:00	SPY	ETF	316.77	316.93	316.05	316.8317	3782882.0
2020-07-07 11:00:00	SPY	ETF	316.83	317.52	316.72	317.26	3384103.0
2020-07-07 11:30:00	SPY	ETF	317.26	317.358	316.58	316.73	2220826.0
2020-07-07 12:00:00	SPY	ETF	316.74	316.98	316.12	316.35	2296611.0
2020-07-07 12:30:00	SPY	ETF	316.34	316.46	315.93	316.37	2802586.0
2020-07-07 13:00:00	SPY	ETF	316.375	317.034	315.72	316.24	4123076.0
2020-07-07 13:30:00	SPY	ETF	316.24	316.44	315.98	316.2	1879104.0
2020-07-07 14:00:00	SPY	ETF	316.2007	316.3	315.61	315.67	4936483.0
2020-07-07 14:30:00	SPY	ETF	315.67	315.675	315.04	315.53	7376048.0
2020-07-07 15:00:00	SPY	ETF	315.53	315.53	314.68	314.98	7394097.0
2020-07-07 15:30:00	SPY	ETF	314.98	315.12	313.37	313.72	17583886.0
2020-07-07 16:00:00	SPY	ETF	313.71	314.5426	313.6075	313.71	8889621.0
2020-07-07 16:30:00	SPY	ETF	313.69	313.8	313.57	313.67	160223.0
2020-07-07 17:00:00	SPY	ETF	313.6	313.75	313.6	313.62	67151.0
2020-07-07 17:30:00	SPY	ETF	313.61	313.76	313.52	313.69	42900.0
2020-07-07 18:00:00	SPY	ETF	313.69	314.09	313.63	313.89	152656.0
2020-07-07 18:30:00	SPY	ETF	313.9	314.04	313.65	313.76	92085.0
2020-07-07 19:00:00	SPY	ETF	313.75	314.18	313.73	314.06	33947.0
2020-07-07 19:30:00	SPY	ETF	314.06	314.26	314.0	314.17	44476.0
2020-07-07 04:00:00	QQQ	ETF	257.59	258.05	257.1	257.19	59905.0
2020-07-07 04:30:00	QQQ	ETF	257.22	257.51	257.12	257.24	13201.0
2020-07-07 05:00:00	QQQ	ETF	257.41	257.41	257.0	257.2	15907.0
2020-07-07 05:30:00	QQQ	ETF	257.28	257.41	257.16	257.35	9606.0
2020-07-07 06:00:00	QQQ	ETF	257.3	257.43	257.01	257.28	74790.0
2020-07-07 06:30:00	QQQ	ETF	257.18	257.52	257.18	257.31	35760.0
2020-07-07 07:00:00	QQQ	ETF	257.37	257.68	257.25	257.63	46499.0
2020-07-07 07:30:00	QQQ	ETF	257.64	257.84	257.42	257.73	70832.0
2020-07-07 08:00:00	QQQ	ETF	257.6199	258.78	257.0196	257.75	168932.0
2020-07-07 08:30:00	QQQ	ETF	257.7	257.96	257.52	257.94	97245.0
2020-07-07 09:00:00	QQQ	ETF	257.93	258.09	257.86	258.09	181523.0
2020-07-07 09:30:00	QQQ	ETF	258.1	259.4	257.54	258.77	5654426.0
2020-07-07 10:00:00	QQQ	ETF	258.79	260.28	258.56	260.0	3019354.0
2020-07-07 10:30:00	QQQ	ETF	260.01	260.35	259.41	260.115	2135896.0
2020-07-07 11:00:00	QQQ	ETF	260.11	260.88	260.0201	260.68	1800341.0
2020-07-07 11:30:00	QQQ	ETF	260.69	260.79	259.8	259.95	1665459.0
2020-07-07 12:00:00	QQQ	ETF	259.97	260.19	258.967	259.29	1471755.0
2020-07-07 12:30:00	QQQ	ETF	259.28	259.57	258.87	259.49	1287797.0

> showing 50 of 20,875 rows — these rows as CSV

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