PREVIEW / etf_30min / 2018-04-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-19.parquet
  size:    462 KB
  rows:    15,757

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
2018-04-19 04:00:00	SPY	ETF	270.41	270.41	270.07	270.35	7205.0
2018-04-19 04:30:00	SPY	ETF	270.3	270.32	269.94	269.94	4260.0
2018-04-19 05:00:00	SPY	ETF	270.0	270.28	270.0	270.19	2000.0
2018-04-19 05:30:00	SPY	ETF	270.23	270.23	270.16	270.23	1700.0
2018-04-19 06:00:00	SPY	ETF	270.2	270.24	269.98	270.04	8270.0
2018-04-19 06:30:00	SPY	ETF	270.08	270.08	269.98	270.03	9450.0
2018-04-19 07:00:00	SPY	ETF	270.08	270.31	270.03	270.23	32708.0
2018-04-19 07:30:00	SPY	ETF	270.29	270.33	270.16	270.21	21019.0
2018-04-19 08:00:00	SPY	ETF	270.22	270.81	269.69	269.74	175920.0
2018-04-19 08:30:00	SPY	ETF	269.8	269.9	269.56	269.6	553847.0
2018-04-19 09:00:00	SPY	ETF	269.56	270.4982	269.41	269.64	441266.0
2018-04-19 09:30:00	SPY	ETF	269.65	269.81	268.81	269.35	6397857.0
2018-04-19 10:00:00	SPY	ETF	269.37	269.745	268.84	269.52	4747630.0
2018-04-19 10:30:00	SPY	ETF	269.51	269.88	268.76	269.125	4710750.0
2018-04-19 11:00:00	SPY	ETF	269.12	269.179	268.565	269.07	3332835.0
2018-04-19 11:30:00	SPY	ETF	269.06	269.12	268.27	268.28	3069444.0
2018-04-19 12:00:00	SPY	ETF	268.27	268.37	267.99	268.17	3418758.0
2018-04-19 12:30:00	SPY	ETF	268.17	268.57	268.1	268.11	3080950.0
2018-04-19 13:00:00	SPY	ETF	268.11	268.18	267.75	267.77	4560429.0
2018-04-19 13:30:00	SPY	ETF	267.76	268.51	267.72	268.3	3652974.0
2018-04-19 14:00:00	SPY	ETF	268.29	268.48	267.84	268.05	2739306.0
2018-04-19 14:30:00	SPY	ETF	268.05	268.56	267.97	268.5	3889287.0
2018-04-19 15:00:00	SPY	ETF	268.49	268.76	268.28	268.31	4657758.0
2018-04-19 15:30:00	SPY	ETF	268.31	269.47	268.21	268.86	16233116.0
2018-04-19 16:00:00	SPY	ETF	268.86	268.98	268.68	268.81	6418523.0
2018-04-19 16:30:00	SPY	ETF	268.81	268.98	268.75	268.91	1531716.0
2018-04-19 17:00:00	SPY	ETF	268.88	268.99	268.88	268.94	97785.0
2018-04-19 17:30:00	SPY	ETF	268.94	268.95	268.81	268.81	31145.0
2018-04-19 18:00:00	SPY	ETF	268.85	269.0	268.8	268.84	26212.0
2018-04-19 18:30:00	SPY	ETF	268.85	268.89	268.81	268.85	1380.0
2018-04-19 19:00:00	SPY	ETF	268.85	268.85	268.35	268.59	18863.0
2018-04-19 19:30:00	SPY	ETF	268.6	268.88	268.56	268.86	10172.0
2018-04-19 04:00:00	QQQ	ETF	166.51	166.6	166.37	166.6	12260.0
2018-04-19 04:30:00	QQQ	ETF	166.57	166.57	166.27	166.27	3900.0
2018-04-19 05:00:00	QQQ	ETF	166.33	166.45	166.33	166.36	8200.0
2018-04-19 05:30:00	QQQ	ETF	166.43	166.46	166.33	166.43	35920.0
2018-04-19 06:00:00	QQQ	ETF	166.36	166.36	166.16	166.23	7900.0
2018-04-19 06:30:00	QQQ	ETF	166.13	166.19	166.03	166.09	152005.0
2018-04-19 07:00:00	QQQ	ETF	166.1	166.28	166.06	166.2	42402.0
2018-04-19 07:30:00	QQQ	ETF	166.21	166.27	166.11	166.25	42328.0
2018-04-19 08:00:00	QQQ	ETF	166.14	166.26	165.86	165.91	167261.0
2018-04-19 08:30:00	QQQ	ETF	165.95	166.0	165.68	165.68	122066.0
2018-04-19 09:00:00	QQQ	ETF	165.68	165.8	165.47	165.66	183511.0
2018-04-19 09:30:00	QQQ	ETF	165.65	165.755	165.1	165.68	2814559.0
2018-04-19 10:00:00	QQQ	ETF	165.68	165.99	165.26	165.61	2657279.0
2018-04-19 10:30:00	QQQ	ETF	165.61	165.79	165.02	165.26	1795912.0
2018-04-19 11:00:00	QQQ	ETF	165.27	165.305	164.68	165.2	2708447.0
2018-04-19 11:30:00	QQQ	ETF	165.19	165.22	164.54	164.56	1719909.0
2018-04-19 12:00:00	QQQ	ETF	164.53	164.78	164.36	164.541	1541886.0
2018-04-19 12:30:00	QQQ	ETF	164.56	164.969	164.48	164.635	1826421.0

> showing 50 of 15,757 rows — these rows as CSV

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