PREVIEW / etf_30min / 2013-06-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-18.parquet
  size:    318 KB
  rows:    10,731

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-06-18 04:00:00	SPY	ETF	164.75	164.96	164.75	164.89	4208.0
2013-06-18 04:30:00	SPY	ETF	164.84	164.92	164.75	164.75	3200.0
2013-06-18 05:00:00	SPY	ETF	164.8	164.96	164.8	164.93	5675.0
2013-06-18 05:30:00	SPY	ETF	164.88	165.07	164.82	165.02	28200.0
2013-06-18 06:00:00	SPY	ETF	164.96	164.98	164.84	164.93	12000.0
2013-06-18 06:30:00	SPY	ETF	164.93	164.93	164.8	164.92	34800.0
2013-06-18 07:00:00	SPY	ETF	164.88	164.93	164.72	164.75	107899.0
2013-06-18 07:30:00	SPY	ETF	164.72	164.72	164.57	164.68	88949.0
2013-06-18 08:00:00	SPY	ETF	164.85	164.91	164.62	164.8	244866.0
2013-06-18 08:30:00	SPY	ETF	164.82	164.88	164.5	164.58	439322.0
2013-06-18 09:00:00	SPY	ETF	164.59	164.65	164.43	164.53	447204.0
2013-06-18 09:30:00	SPY	ETF	164.53	164.96	164.52	164.74	9760140.0
2013-06-18 10:00:00	SPY	ETF	164.745	165.12	164.64	165.04	6502807.0
2013-06-18 10:30:00	SPY	ETF	165.04	165.39	165.03	165.33	6585533.0
2013-06-18 11:00:00	SPY	ETF	165.33	165.52	165.18	165.51	6704572.0
2013-06-18 11:30:00	SPY	ETF	165.51	165.69	165.36	165.4	7089467.0
2013-06-18 12:00:00	SPY	ETF	165.39	165.46	165.29	165.38	3521246.0
2013-06-18 12:30:00	SPY	ETF	165.38	165.78	165.38	165.75	5584773.0
2013-06-18 13:00:00	SPY	ETF	165.74	165.77	165.48	165.545	3522121.0
2013-06-18 13:30:00	SPY	ETF	165.55	165.78	165.42	165.71	3668257.0
2013-06-18 14:00:00	SPY	ETF	165.7093	165.93	165.56	165.7901	7199270.0
2013-06-18 14:30:00	SPY	ETF	165.8	165.99	165.76	165.93	5059314.0
2013-06-18 15:00:00	SPY	ETF	165.92	165.93	165.64	165.925	7739232.0
2013-06-18 15:30:00	SPY	ETF	165.92	165.94	165.5	165.74	17249638.0
2013-06-18 16:00:00	SPY	ETF	165.74	165.86	165.5774	165.78	4154076.0
2013-06-18 16:30:00	SPY	ETF	165.77	165.85	165.76	165.79	4946599.0
2013-06-18 17:00:00	SPY	ETF	165.8	165.85	165.8	165.85	572470.0
2013-06-18 17:30:00	SPY	ETF	165.85	165.85	165.8	165.8	64651.0
2013-06-18 18:00:00	SPY	ETF	165.79	165.85	165.75	165.76	48087.0
2013-06-18 18:30:00	SPY	ETF	165.79	165.8	165.78	165.8	5820.0
2013-06-18 19:00:00	SPY	ETF	165.78	165.8	165.78	165.79	2065.0
2013-06-18 19:30:00	SPY	ETF	165.8	165.8	165.72	165.74	47191.0
2013-06-18 04:00:00	QQQ	ETF	73.08	73.16	73.08	73.13	2400.0
2013-06-18 04:30:00	QQQ	ETF	73.1	73.1	73.07	73.07	800.0
2013-06-18 05:00:00	QQQ	ETF	73.08	73.13	73.08	73.13	900.0
2013-06-18 05:30:00	QQQ	ETF	73.16	73.19	73.16	73.16	1200.0
2013-06-18 06:00:00	QQQ	ETF	73.13	73.13	73.1	73.13	1200.0
2013-06-18 06:30:00	QQQ	ETF	73.1	73.13	73.1	73.13	1000.0
2013-06-18 07:00:00	QQQ	ETF	73.1	73.1	73.07	73.1	1300.0
2013-06-18 07:30:00	QQQ	ETF	73.08	73.08	73.01	73.06	2650.0
2013-06-18 08:00:00	QQQ	ETF	73.05	73.1	73.01	73.1	6000.0
2013-06-18 08:30:00	QQQ	ETF	73.12	73.19	73.06	73.06	42882.0
2013-06-18 09:00:00	QQQ	ETF	73.06	73.09	73.04	73.05	71286.0
2013-06-18 09:30:00	QQQ	ETF	73.07	73.3399	73.06	73.24	2735741.0
2013-06-18 10:00:00	QQQ	ETF	73.23	73.38	73.2	73.36	1648410.0
2013-06-18 10:30:00	QQQ	ETF	73.37	73.6	73.3673	73.55	2180754.0
2013-06-18 11:00:00	QQQ	ETF	73.55	73.61	73.49	73.61	1616727.0
2013-06-18 11:30:00	QQQ	ETF	73.61	73.69	73.53	73.54	1364224.0
2013-06-18 12:00:00	QQQ	ETF	73.54	73.55	73.45	73.49	754050.0
2013-06-18 12:30:00	QQQ	ETF	73.49	73.64	73.49	73.62	790153.0

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

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