PREVIEW / etf_30min / 2020-06-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-15.parquet
  size:    568 KB
  rows:    21,222

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-06-15 04:00:00	SPY	ETF	296.36	297.28	295.91	297.0	182068.0
2020-06-15 04:30:00	SPY	ETF	297.0	298.62	296.98	298.52	72548.0
2020-06-15 05:00:00	SPY	ETF	298.49	298.64	297.51	298.47	38928.0
2020-06-15 05:30:00	SPY	ETF	298.45	299.32	297.86	299.23	79707.0
2020-06-15 06:00:00	SPY	ETF	299.11	299.54	298.5	298.53	89503.0
2020-06-15 06:30:00	SPY	ETF	298.45	298.68	297.13	297.3	99936.0
2020-06-15 07:00:00	SPY	ETF	297.24	298.4	296.98	297.9	486960.0
2020-06-15 07:30:00	SPY	ETF	297.87	299.28	297.65	298.25	382154.0
2020-06-15 08:00:00	SPY	ETF	298.29	301.05	295.39	297.8337	738427.0
2020-06-15 08:30:00	SPY	ETF	297.82	298.58	297.73	298.09	353837.0
2020-06-15 09:00:00	SPY	ETF	298.05	298.44	297.54	298.02	641882.0
2020-06-15 09:30:00	SPY	ETF	298.02	300.11	296.74	299.95	13440714.0
2020-06-15 10:00:00	SPY	ETF	299.94	301.33	299.4	299.9906	10960239.0
2020-06-15 10:30:00	SPY	ETF	299.99	301.7593	299.27	300.93	9707718.0
2020-06-15 11:00:00	SPY	ETF	300.93	302.63	300.75	301.77	8387797.0
2020-06-15 11:30:00	SPY	ETF	301.78	302.29	301.05	301.915	6815643.0
2020-06-15 12:00:00	SPY	ETF	301.89	303.79	301.645	303.56	6628337.0
2020-06-15 12:30:00	SPY	ETF	303.56	304.42	303.06	304.37	5652694.0
2020-06-15 13:00:00	SPY	ETF	304.36	305.31	304.09	304.46	6224721.0
2020-06-15 13:30:00	SPY	ETF	304.46	304.83	303.81	304.06	5193766.0
2020-06-15 14:00:00	SPY	ETF	304.06	308.22	304.0597	307.9	16968788.0
2020-06-15 14:30:00	SPY	ETF	307.92	308.28	306.52	306.73	8175812.0
2020-06-15 15:00:00	SPY	ETF	306.74	307.785	305.84	305.9	7556720.0
2020-06-15 15:30:00	SPY	ETF	305.86	307.12	304.54	307.03	17385975.0
2020-06-15 16:00:00	SPY	ETF	307.03	307.72	306.4624	307.48	5944974.0
2020-06-15 16:30:00	SPY	ETF	307.5	308.06	307.05	308.0	630430.0
2020-06-15 17:00:00	SPY	ETF	307.99	308.06	307.85	307.97	281484.0
2020-06-15 17:30:00	SPY	ETF	308.0	308.15	307.05	308.15	582961.0
2020-06-15 18:00:00	SPY	ETF	308.15	308.91	307.05	308.27	260592.0
2020-06-15 18:30:00	SPY	ETF	308.34	308.51	307.58	308.36	105201.0
2020-06-15 19:00:00	SPY	ETF	308.41	308.75	307.5	308.7	124409.0
2020-06-15 19:30:00	SPY	ETF	308.6801	310.17	308.56	310.15	322752.0
2020-06-15 04:00:00	QQQ	ETF	230.75	231.38	230.44	231.18	37477.0
2020-06-15 04:30:00	QQQ	ETF	231.2	231.89	231.2	231.89	15700.0
2020-06-15 05:00:00	QQQ	ETF	231.76	231.95	231.27	231.91	19490.0
2020-06-15 05:30:00	QQQ	ETF	231.7	232.55	231.4	232.44	27388.0
2020-06-15 06:00:00	QQQ	ETF	232.46	232.82	232.19	232.19	38511.0
2020-06-15 06:30:00	QQQ	ETF	232.03	232.35	231.47	231.47	29162.0
2020-06-15 07:00:00	QQQ	ETF	231.48	232.46	231.35	232.2	130036.0
2020-06-15 07:30:00	QQQ	ETF	232.04	232.87	231.9	232.47	135252.0
2020-06-15 08:00:00	QQQ	ETF	232.49	233.25	229.5	232.58	168207.0
2020-06-15 08:30:00	QQQ	ETF	232.55	232.72	232.24	232.43	158311.0
2020-06-15 09:00:00	QQQ	ETF	232.47	232.8	232.11	232.41	308397.0
2020-06-15 09:30:00	QQQ	ETF	232.44	234.305	231.47	234.24	6100224.0
2020-06-15 10:00:00	QQQ	ETF	234.22	235.19	233.87	234.08	3764645.0
2020-06-15 10:30:00	QQQ	ETF	234.07	234.89	233.27	234.07	2902940.0
2020-06-15 11:00:00	QQQ	ETF	234.07	235.27	233.92	234.76	2285776.0
2020-06-15 11:30:00	QQQ	ETF	234.77	235.24	234.21	234.95	2284138.0
2020-06-15 12:00:00	QQQ	ETF	234.93	236.22	234.77	236.0	2105852.0
2020-06-15 12:30:00	QQQ	ETF	235.995	236.46	235.66	236.46	1626994.0

> showing 50 of 21,222 rows — these rows as CSV

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