PREVIEW / etf_30min / 2013-10-14

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-14.parquet
  size:    326 KB
  rows:    10,727

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
2013-10-14 04:00:00	SPY	ETF	169.54	169.54	169.2	169.23	64076.0
2013-10-14 04:30:00	SPY	ETF	169.21	169.27	169.15	169.27	5904.0
2013-10-14 05:00:00	SPY	ETF	169.29	169.29	169.17	169.25	15441.0
2013-10-14 05:30:00	SPY	ETF	169.27	169.29	169.18	169.18	10586.0
2013-10-14 06:00:00	SPY	ETF	169.2	169.36	169.16	169.25	22000.0
2013-10-14 06:30:00	SPY	ETF	169.25	169.33	169.2	169.3	74780.0
2013-10-14 07:00:00	SPY	ETF	169.32	169.39	169.25	169.3	208906.0
2013-10-14 07:30:00	SPY	ETF	169.31	169.31	169.15	169.15	342921.0
2013-10-14 08:00:00	SPY	ETF	169.17	169.36	168.96	169.05	545456.0
2013-10-14 08:30:00	SPY	ETF	169.02	169.21	169.0	169.12	432914.0
2013-10-14 09:00:00	SPY	ETF	169.11	169.26	169.11	169.21	721961.0
2013-10-14 09:30:00	SPY	ETF	169.21	169.67	169.08	169.505	11454169.0
2013-10-14 10:00:00	SPY	ETF	169.5	169.66	169.28	169.52	6091859.0
2013-10-14 10:30:00	SPY	ETF	169.53	169.6	169.28	169.42	5576705.0
2013-10-14 11:00:00	SPY	ETF	169.42	169.56	169.34	169.56	3028671.0
2013-10-14 11:30:00	SPY	ETF	169.56	170.11	169.55	170.07	7912005.0
2013-10-14 12:00:00	SPY	ETF	170.07	170.18	169.88	169.913	4298391.0
2013-10-14 12:30:00	SPY	ETF	169.92	170.17	169.91	170.15	4267956.0
2013-10-14 13:00:00	SPY	ETF	170.15	170.55	170.07	170.43	5243923.0
2013-10-14 13:30:00	SPY	ETF	170.43	170.64	170.4	170.52	6180299.0
2013-10-14 14:00:00	SPY	ETF	170.51	170.92	170.47	170.78	6963222.0
2013-10-14 14:30:00	SPY	ETF	170.79	170.94	170.48	170.68	10449588.0
2013-10-14 15:00:00	SPY	ETF	170.685	171.08	170.57	170.8899	7286260.0
2013-10-14 15:30:00	SPY	ETF	170.88	171.03	170.6	170.97	16485715.0
2013-10-14 16:00:00	SPY	ETF	170.96	171.05	170.2572	170.95	10311343.0
2013-10-14 16:30:00	SPY	ETF	170.95	171.13	169.49	171.06	789622.0
2013-10-14 17:00:00	SPY	ETF	171.07	171.13	171.04	171.04	152693.0
2013-10-14 17:30:00	SPY	ETF	171.06	171.09	171.0	171.09	101993.0
2013-10-14 18:00:00	SPY	ETF	171.09	171.12	171.02	171.12	107436.0
2013-10-14 18:30:00	SPY	ETF	171.1	171.1	170.97	170.97	10600.0
2013-10-14 19:00:00	SPY	ETF	170.98	171.04	170.96	171.04	25878.0
2013-10-14 19:30:00	SPY	ETF	171.04	171.42	171.02	171.31	63335.0
2013-10-14 04:00:00	QQQ	ETF	78.86	78.88	78.8	78.81	15500.0
2013-10-14 04:30:00	QQQ	ETF	78.8	78.83	78.77	78.83	4100.0
2013-10-14 05:00:00	QQQ	ETF	78.82	78.82	78.78	78.81	6100.0
2013-10-14 05:30:00	QQQ	ETF	78.8	78.83	78.78	78.78	4500.0
2013-10-14 06:00:00	QQQ	ETF	78.79	78.89	78.78	78.83	11800.0
2013-10-14 06:30:00	QQQ	ETF	78.82	78.88	78.81	78.85	50800.0
2013-10-14 07:00:00	QQQ	ETF	78.86	78.86	78.83	78.84	13182.0
2013-10-14 07:30:00	QQQ	ETF	78.84	78.84	78.78	78.79	20842.0
2013-10-14 08:00:00	QQQ	ETF	78.79	78.87	78.62	78.69	110813.0
2013-10-14 08:30:00	QQQ	ETF	78.7	78.75	78.69	78.73	58509.0
2013-10-14 09:00:00	QQQ	ETF	78.72	78.77	78.71	78.74	75014.0
2013-10-14 09:30:00	QQQ	ETF	78.74	79.06	78.68	79.05	3816704.0
2013-10-14 10:00:00	QQQ	ETF	79.05	79.109	78.89	79.03	2238253.0
2013-10-14 10:30:00	QQQ	ETF	79.03	79.11	78.84	78.91	1518551.0
2013-10-14 11:00:00	QQQ	ETF	78.91	79.03	78.88	79.0114	990316.0
2013-10-14 11:30:00	QQQ	ETF	79.01	79.33	79.005	79.3065	2207779.0
2013-10-14 12:00:00	QQQ	ETF	79.31	79.33	79.22	79.27	1650272.0
2013-10-14 12:30:00	QQQ	ETF	79.28	79.435	79.27	79.42	1647676.0

> showing 50 of 10,727 rows — these rows as CSV

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