PREVIEW / etf_30min / 2013-05-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-15.parquet
  size:    326 KB
  rows:    10,843

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-05-15 04:00:00	SPY	ETF	165.23	165.23	165.08	165.08	1320.0
2013-05-15 04:30:00	SPY	ETF	164.98	165.01	164.95	165.0	5200.0
2013-05-15 05:00:00	SPY	ETF	164.98	164.98	164.9	164.91	24300.0
2013-05-15 05:30:00	SPY	ETF	164.91	165.11	164.9	165.1	15540.0
2013-05-15 06:00:00	SPY	ETF	165.16	165.21	165.11	165.18	12900.0
2013-05-15 06:30:00	SPY	ETF	165.2	165.3	165.2	165.275	40314.0
2013-05-15 07:00:00	SPY	ETF	165.27	165.3	165.13	165.13	46800.0
2013-05-15 07:30:00	SPY	ETF	165.1	165.17	165.07	165.13	42850.0
2013-05-15 08:00:00	SPY	ETF	165.15	165.27	165.04	165.07	173822.0
2013-05-15 08:30:00	SPY	ETF	165.05	165.28	164.9	165.05	669027.0
2013-05-15 09:00:00	SPY	ETF	165.05	165.05	164.77	164.97	770586.0
2013-05-15 09:30:00	SPY	ETF	164.96	165.23	164.91	165.13	9690835.0
2013-05-15 10:00:00	SPY	ETF	165.13	165.29	165.06	165.1113	6891716.0
2013-05-15 10:30:00	SPY	ETF	165.12	165.39	165.08	165.38	5164972.0
2013-05-15 11:00:00	SPY	ETF	165.37	165.76	165.37	165.64	8058313.0
2013-05-15 11:30:00	SPY	ETF	165.645	165.99	165.58	165.97	5323336.0
2013-05-15 12:00:00	SPY	ETF	165.97	166.26	165.9	166.17	6704888.0
2013-05-15 12:30:00	SPY	ETF	166.18	166.45	166.16	166.275	7587601.0
2013-05-15 13:00:00	SPY	ETF	166.28	166.29	165.94	166.01	7410262.0
2013-05-15 13:30:00	SPY	ETF	166.01	166.14	165.73	165.74	6513147.0
2013-05-15 14:00:00	SPY	ETF	165.731	165.855	165.47	165.68	9107534.0
2013-05-15 14:30:00	SPY	ETF	165.69	165.77	165.35	165.54	8734510.0
2013-05-15 15:00:00	SPY	ETF	165.53	165.89	165.39	165.732	8288191.0
2013-05-15 15:30:00	SPY	ETF	165.76	166.19	165.76	166.1	15509735.0
2013-05-15 16:00:00	SPY	ETF	166.08	166.31	165.3031	165.94	8696387.0
2013-05-15 16:30:00	SPY	ETF	165.92	166.296	165.5113	165.95	2063294.0
2013-05-15 17:00:00	SPY	ETF	165.96	166.03	165.93	166.01	203634.0
2013-05-15 17:30:00	SPY	ETF	166.01	166.05	165.96	166.05	68663.0
2013-05-15 18:00:00	SPY	ETF	166.04	166.04	165.87	165.94	36050.0
2013-05-15 18:30:00	SPY	ETF	165.92	165.93	165.86	165.93	45410.0
2013-05-15 19:00:00	SPY	ETF	165.92	165.96	165.9	165.96	13902.0
2013-05-15 19:30:00	SPY	ETF	165.97	166.02	165.95	166.0	20626.0
2013-05-15 05:30:00	QQQ	ETF	73.44	73.44	73.44	73.44	100.0
2013-05-15 06:00:00	QQQ	ETF	73.52	73.52	73.5	73.5	1000.0
2013-05-15 07:00:00	QQQ	ETF	73.55	73.55	73.55	73.55	1000.0
2013-05-15 07:30:00	QQQ	ETF	73.49	73.52	73.49	73.49	11700.0
2013-05-15 08:00:00	QQQ	ETF	73.54	73.54	73.49	73.49	7502.0
2013-05-15 08:30:00	QQQ	ETF	73.49	73.49	73.43	73.43	30742.0
2013-05-15 09:00:00	QQQ	ETF	73.42	73.45	73.33	73.38	52141.0
2013-05-15 09:30:00	QQQ	ETF	73.38	73.6399	73.34	73.46	2053821.0
2013-05-15 10:00:00	QQQ	ETF	73.451	73.58	73.38	73.42	1488439.0
2013-05-15 10:30:00	QQQ	ETF	73.42	73.63	73.42	73.62	1288757.0
2013-05-15 11:00:00	QQQ	ETF	73.63	73.74	73.62	73.63	1424660.0
2013-05-15 11:30:00	QQQ	ETF	73.6301	73.69	73.59	73.629	933162.0
2013-05-15 12:00:00	QQQ	ETF	73.62	73.6901	73.58	73.64	1266697.0
2013-05-15 12:30:00	QQQ	ETF	73.65	73.73	73.649	73.68	1087627.0
2013-05-15 13:00:00	QQQ	ETF	73.67	73.68	73.43	73.49	1490716.0
2013-05-15 13:30:00	QQQ	ETF	73.48	73.53	73.37	73.37	1316999.0
2013-05-15 14:00:00	QQQ	ETF	73.3717	73.459	73.24	73.32	1684867.0
2013-05-15 14:30:00	QQQ	ETF	73.3122	73.37	73.2	73.315	1523146.0

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

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