PREVIEW / etf_30min / 2013-08-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-23.parquet
  size:    309 KB
  rows:    10,547

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-08-23 04:00:00	SPY	ETF	165.93	165.96	165.74	165.96	9700.0
2013-08-23 04:30:00	SPY	ETF	165.99	166.03	165.73	165.74	13170.0
2013-08-23 05:00:00	SPY	ETF	165.76	165.84	165.7	165.78	12600.0
2013-08-23 05:30:00	SPY	ETF	165.8	165.88	165.78	165.84	3900.0
2013-08-23 06:00:00	SPY	ETF	165.88	165.89	165.81	165.88	36602.0
2013-08-23 06:30:00	SPY	ETF	165.85	165.92	165.84	165.92	16700.0
2013-08-23 07:00:00	SPY	ETF	165.93	165.96	165.9	165.93	94364.0
2013-08-23 07:30:00	SPY	ETF	165.96	166.15	165.96	166.1	197977.0
2013-08-23 08:00:00	SPY	ETF	166.12	166.25	165.93	166.22	208680.0
2013-08-23 08:30:00	SPY	ETF	166.21	166.24	166.06	166.17	174979.0
2013-08-23 09:00:00	SPY	ETF	166.14	166.66	166.11	166.54	1243687.0
2013-08-23 09:30:00	SPY	ETF	166.55	166.55	166.01	166.15	10949187.0
2013-08-23 10:00:00	SPY	ETF	166.15	166.21	165.77	165.98	10124430.0
2013-08-23 10:30:00	SPY	ETF	165.97	166.53	165.94	166.42	8289181.0
2013-08-23 11:00:00	SPY	ETF	166.43	166.519	166.12	166.1903	4234623.0
2013-08-23 11:30:00	SPY	ETF	166.2	166.37	166.14	166.22	3172475.0
2013-08-23 12:00:00	SPY	ETF	166.22	166.33	166.2	166.27	2947487.0
2013-08-23 12:30:00	SPY	ETF	166.26	166.43	166.24	166.42	3434815.0
2013-08-23 13:00:00	SPY	ETF	166.4101	166.42	166.29	166.37	3504659.0
2013-08-23 13:30:00	SPY	ETF	166.37	166.49	166.32	166.415	1940855.0
2013-08-23 14:00:00	SPY	ETF	166.415	166.42	166.29	166.34	2006070.0
2013-08-23 14:30:00	SPY	ETF	166.345	166.48	166.33	166.441	2125800.0
2013-08-23 15:00:00	SPY	ETF	166.45	166.56	166.37	166.55	4347714.0
2013-08-23 15:30:00	SPY	ETF	166.555	166.83	166.44	166.59	14395427.0
2013-08-23 16:00:00	SPY	ETF	166.59	166.78	166.0185	166.66	9884399.0
2013-08-23 16:30:00	SPY	ETF	166.68	166.73	166.65	166.73	2207317.0
2013-08-23 17:00:00	SPY	ETF	166.73	166.73	166.65	166.65	115701.0
2013-08-23 17:30:00	SPY	ETF	166.65	166.68	166.64	166.64	12900.0
2013-08-23 18:00:00	SPY	ETF	166.69	166.74	166.69	166.71	4991.0
2013-08-23 18:30:00	SPY	ETF	166.71	166.71	166.68	166.7	1400.0
2013-08-23 19:00:00	SPY	ETF	166.7	166.72	166.67	166.68	4650.0
2013-08-23 19:30:00	SPY	ETF	166.69	166.71	166.67	166.71	9716.0
2013-08-23 04:00:00	QQQ	ETF	76.24	76.24	76.09	76.21	15400.0
2013-08-23 04:30:00	QQQ	ETF	76.19	76.19	76.07	76.07	8700.0
2013-08-23 05:00:00	QQQ	ETF	76.09	76.11	76.05	76.09	9400.0
2013-08-23 05:30:00	QQQ	ETF	76.11	76.13	76.11	76.13	4100.0
2013-08-23 06:00:00	QQQ	ETF	76.15	76.15	76.11	76.14	4740.0
2013-08-23 06:30:00	QQQ	ETF	76.15	76.16	76.13	76.16	51400.0
2013-08-23 07:00:00	QQQ	ETF	76.17	76.17	76.17	76.17	1000.0
2013-08-23 07:30:00	QQQ	ETF	76.19	76.25	76.19	76.25	7400.0
2013-08-23 08:00:00	QQQ	ETF	76.17	76.28	76.16	76.28	14666.0
2013-08-23 08:30:00	QQQ	ETF	76.27	76.28	76.2	76.25	27801.0
2013-08-23 09:00:00	QQQ	ETF	76.25	76.78	76.24	76.72	1116883.0
2013-08-23 09:30:00	QQQ	ETF	76.72	76.761	76.49	76.57	4133602.0
2013-08-23 10:00:00	QQQ	ETF	76.56	76.63	76.4	76.48	2411783.0
2013-08-23 10:30:00	QQQ	ETF	76.49	76.68	76.48	76.61	1493659.0
2013-08-23 11:00:00	QQQ	ETF	76.6003	76.64	76.47	76.52	1353104.0
2013-08-23 11:30:00	QQQ	ETF	76.515	76.55	76.4501	76.52	624730.0
2013-08-23 12:00:00	QQQ	ETF	76.53	76.61	76.51	76.59	437656.0
2013-08-23 12:30:00	QQQ	ETF	76.595	76.67	76.59	76.631	620997.0

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

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