PREVIEW / etf_30min / 2017-06-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-21.parquet
  size:    433 KB
  rows:    14,865

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
2017-06-21 04:00:00	SPY	ETF	242.75	242.81	242.46	242.65	12459.0
2017-06-21 04:30:00	SPY	ETF	242.63	242.91	242.63	242.76	60900.0
2017-06-21 05:00:00	SPY	ETF	242.76	242.86	242.55	242.65	17300.0
2017-06-21 05:30:00	SPY	ETF	242.67	242.72	242.54	242.72	6160.0
2017-06-21 06:00:00	SPY	ETF	242.72	242.82	242.72	242.82	61190.0
2017-06-21 06:30:00	SPY	ETF	242.82	243.01	242.82	243.01	64050.0
2017-06-21 07:00:00	SPY	ETF	243.06	243.12	242.84	242.84	98423.0
2017-06-21 07:30:00	SPY	ETF	242.83	242.94	242.8	242.88	234132.0
2017-06-21 08:00:00	SPY	ETF	242.88	243.27	242.86	243.22	183853.0
2017-06-21 08:30:00	SPY	ETF	243.22	243.28	243.18	243.22	190664.0
2017-06-21 09:00:00	SPY	ETF	243.23	243.46	243.23	243.43	290181.0
2017-06-21 09:30:00	SPY	ETF	243.42	243.46	243.05	243.1	5400856.0
2017-06-21 10:00:00	SPY	ETF	243.085	243.3	243.06	243.18	3730596.0
2017-06-21 10:30:00	SPY	ETF	243.18	243.59	243.16	243.23	4591404.0
2017-06-21 11:00:00	SPY	ETF	243.225	243.23	242.66	242.85	4601872.0
2017-06-21 11:30:00	SPY	ETF	242.85	243.2	242.81	243.17	2573011.0
2017-06-21 12:00:00	SPY	ETF	243.18	243.1899	242.93	243.08	1574710.0
2017-06-21 12:30:00	SPY	ETF	243.09	243.18	242.66	242.6744	2276516.0
2017-06-21 13:00:00	SPY	ETF	242.675	242.86	242.63	242.76	1798056.0
2017-06-21 13:30:00	SPY	ETF	242.77	242.87	242.41	242.56	3020826.0
2017-06-21 14:00:00	SPY	ETF	242.56	242.77	242.44	242.58	2727571.0
2017-06-21 14:30:00	SPY	ETF	242.58	243.06	242.565	242.94	3518542.0
2017-06-21 15:00:00	SPY	ETF	242.94	243.01	242.82	242.94	4882311.0
2017-06-21 15:30:00	SPY	ETF	242.94	243.04	242.68	242.95	7173660.0
2017-06-21 16:00:00	SPY	ETF	242.94	243.02	242.83	242.96	4796593.0
2017-06-21 16:30:00	SPY	ETF	242.95	242.95	242.5	242.85	215192.0
2017-06-21 17:00:00	SPY	ETF	242.83	242.85	242.75	242.78	147619.0
2017-06-21 17:30:00	SPY	ETF	242.79	242.8	242.77	242.77	23377.0
2017-06-21 18:00:00	SPY	ETF	242.77	242.79	242.57	242.58	72444.0
2017-06-21 18:30:00	SPY	ETF	242.59	242.68	242.59	242.63	46737.0
2017-06-21 19:00:00	SPY	ETF	242.63	242.8	242.57	242.72	41031.0
2017-06-21 19:30:00	SPY	ETF	242.7	242.73	242.63	242.63	15183.0
2017-06-21 04:00:00	QQQ	ETF	139.04	139.04	138.58	138.82	6560.0
2017-06-21 04:30:00	QQQ	ETF	138.89	139.0	138.8	139.0	18821.0
2017-06-21 05:00:00	QQQ	ETF	138.95	138.95	138.79	138.79	3828.0
2017-06-21 05:30:00	QQQ	ETF	138.81	138.86	138.73	138.86	24857.0
2017-06-21 06:00:00	QQQ	ETF	138.95	139.02	138.9	139.02	57782.0
2017-06-21 06:30:00	QQQ	ETF	139.04	139.18	139.0	139.18	6003.0
2017-06-21 07:00:00	QQQ	ETF	139.2	139.24	139.01	139.01	89393.0
2017-06-21 07:30:00	QQQ	ETF	139.05	139.14	139.04	139.13	42290.0
2017-06-21 08:00:00	QQQ	ETF	139.05	139.6	139.05	139.59	78808.0
2017-06-21 08:30:00	QQQ	ETF	139.54	139.58	139.5	139.55	25777.0
2017-06-21 09:00:00	QQQ	ETF	139.55	139.78	139.55	139.68	194416.0
2017-06-21 09:30:00	QQQ	ETF	139.66	139.96	139.59	139.67	3644683.0
2017-06-21 10:00:00	QQQ	ETF	139.662	140.04	139.66	139.95	2866799.0
2017-06-21 10:30:00	QQQ	ETF	139.95	140.41	139.95	140.24	4107405.0
2017-06-21 11:00:00	QQQ	ETF	140.235	140.235	139.88	140.12	2174734.0
2017-06-21 11:30:00	QQQ	ETF	140.11	140.38	140.085	140.37	1512870.0
2017-06-21 12:00:00	QQQ	ETF	140.36	140.37	140.159	140.3544	1112193.0
2017-06-21 12:30:00	QQQ	ETF	140.3599	140.5	140.12	140.16	2027606.0

> showing 50 of 14,865 rows — these rows as CSV

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