PREVIEW / etf_30min / 2013-04-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-03.parquet
  size:    322 KB
  rows:    10,685

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-04-03 04:00:00	SPY	ETF	156.8	157.15	156.8	157.15	12079.0
2013-04-03 04:30:00	SPY	ETF	157.16	157.16	157.08	157.08	3700.0
2013-04-03 05:00:00	SPY	ETF	157.14	157.18	157.1	157.18	76502.0
2013-04-03 05:30:00	SPY	ETF	157.2	157.2	157.14	157.17	33300.0
2013-04-03 06:00:00	SPY	ETF	157.17	157.17	157.08	157.08	7050.0
2013-04-03 06:30:00	SPY	ETF	157.08	157.12	157.06	157.06	2500.0
2013-04-03 07:00:00	SPY	ETF	157.06	157.06	156.94	156.98	156757.0
2013-04-03 07:30:00	SPY	ETF	156.97	157.1	156.89	157.1	254317.0
2013-04-03 08:00:00	SPY	ETF	157.07	157.2	156.85	156.91	1865236.0
2013-04-03 08:30:00	SPY	ETF	156.91	156.99	156.82	156.94	408403.0
2013-04-03 09:00:00	SPY	ETF	156.93	156.995	156.9	156.91	531388.0
2013-04-03 09:30:00	SPY	ETF	156.91	157.03	156.44	156.52	12927723.0
2013-04-03 10:00:00	SPY	ETF	156.51	156.59	156.13	156.33	14328961.0
2013-04-03 10:30:00	SPY	ETF	156.34	156.35	155.98	156.02	10831343.0
2013-04-03 11:00:00	SPY	ETF	156.02	156.07	155.75	155.94	9258762.0
2013-04-03 11:30:00	SPY	ETF	155.94	156.075	155.76	156.04	5735800.0
2013-04-03 12:00:00	SPY	ETF	156.035	156.04	155.711	155.7299	5002171.0
2013-04-03 12:30:00	SPY	ETF	155.73	155.87	155.54	155.66	6181730.0
2013-04-03 13:00:00	SPY	ETF	155.65	155.76	155.51	155.541	5527377.0
2013-04-03 13:30:00	SPY	ETF	155.54	155.55	155.11	155.125	12784535.0
2013-04-03 14:00:00	SPY	ETF	155.12	155.42	155.06	155.23	11252055.0
2013-04-03 14:30:00	SPY	ETF	155.24	155.62	155.19	155.55	9923120.0
2013-04-03 15:00:00	SPY	ETF	155.55	155.55	155.225	155.3	8012099.0
2013-04-03 15:30:00	SPY	ETF	155.29	155.48	154.82	155.26	26746846.0
2013-04-03 16:00:00	SPY	ETF	155.24	156.8877	155.15	155.25	6071899.0
2013-04-03 16:30:00	SPY	ETF	155.26	155.32	155.22	155.31	878716.0
2013-04-03 17:00:00	SPY	ETF	155.33	155.35	155.31	155.31	66628.0
2013-04-03 17:30:00	SPY	ETF	155.33	155.36	155.31	155.31	64274.0
2013-04-03 18:00:00	SPY	ETF	155.3	155.3	155.03	155.21	164166.0
2013-04-03 18:30:00	SPY	ETF	155.22	155.34	155.18	155.24	76322.0
2013-04-03 19:00:00	SPY	ETF	155.2	155.35	155.2	155.32	40066.0
2013-04-03 19:30:00	SPY	ETF	155.27	155.36	155.27	155.31	23741.0
2013-04-03 04:00:00	QQQ	ETF	69.08	69.11	69.08	69.11	12000.0
2013-04-03 07:00:00	QQQ	ETF	69.07	69.08	69.07	69.08	2000.0
2013-04-03 07:30:00	QQQ	ETF	69.05	69.14	69.05	69.13	559900.0
2013-04-03 08:00:00	QQQ	ETF	69.13	69.15	69.05	69.08	924020.0
2013-04-03 08:30:00	QQQ	ETF	69.07	69.08	69.05	69.07	49100.0
2013-04-03 09:00:00	QQQ	ETF	69.09	69.12	69.07	69.1	99081.0
2013-04-03 09:30:00	QQQ	ETF	69.08	69.18	69.03	69.0799	3654905.0
2013-04-03 10:00:00	QQQ	ETF	69.07	69.1	68.89	69.02	1964456.0
2013-04-03 10:30:00	QQQ	ETF	69.02	69.035	68.91	68.93	1479588.0
2013-04-03 11:00:00	QQQ	ETF	68.92	68.94	68.795	68.83	1247936.0
2013-04-03 11:30:00	QQQ	ETF	68.83	68.9	68.8	68.898	911813.0
2013-04-03 12:00:00	QQQ	ETF	68.89	68.89	68.72	68.73	694759.0
2013-04-03 12:30:00	QQQ	ETF	68.722	68.78	68.6	68.639	1433054.0
2013-04-03 13:00:00	QQQ	ETF	68.639	68.67	68.555	68.59	2500137.0
2013-04-03 13:30:00	QQQ	ETF	68.585	68.59	68.295	68.3	3917989.0
2013-04-03 14:00:00	QQQ	ETF	68.3	68.47	68.28	68.39	3255076.0
2013-04-03 14:30:00	QQQ	ETF	68.39	68.53	68.37	68.51	2309377.0
2013-04-03 15:00:00	QQQ	ETF	68.515	68.515	68.395	68.43	1256197.0

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

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