PREVIEW / etf_30min / 2013-08-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-09.parquet
  size:    303 KB
  rows:    10,369

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-09 04:00:00	SPY	ETF	169.85	169.85	169.44	169.44	5900.0
2013-08-09 04:30:00	SPY	ETF	169.41	169.44	169.35	169.42	10000.0
2013-08-09 05:00:00	SPY	ETF	169.44	169.49	169.4	169.4	31000.0
2013-08-09 05:30:00	SPY	ETF	169.41	169.41	169.35	169.35	1100.0
2013-08-09 06:00:00	SPY	ETF	169.32	169.32	169.13	169.21	5923.0
2013-08-09 06:30:00	SPY	ETF	169.21	169.26	169.14	169.26	13100.0
2013-08-09 07:00:00	SPY	ETF	169.27	169.33	169.24	169.33	55918.0
2013-08-09 07:30:00	SPY	ETF	169.31	169.44	169.31	169.41	52945.0
2013-08-09 08:00:00	SPY	ETF	169.31	169.48	169.24	169.44	277852.0
2013-08-09 08:30:00	SPY	ETF	169.45	169.47	169.23	169.38	322396.0
2013-08-09 09:00:00	SPY	ETF	169.35	169.61	169.32	169.59	410754.0
2013-08-09 09:30:00	SPY	ETF	169.58	170.1	169.51	169.97	9271650.0
2013-08-09 10:00:00	SPY	ETF	169.97	170.02	169.39	169.54	8532568.0
2013-08-09 10:30:00	SPY	ETF	169.54	169.76	169.31	169.375	5424852.0
2013-08-09 11:00:00	SPY	ETF	169.37	169.379	168.72	168.89	10681264.0
2013-08-09 11:30:00	SPY	ETF	168.89	169.235	168.8401	169.14	7124690.0
2013-08-09 12:00:00	SPY	ETF	169.14	169.36	169.0	169.31	6040245.0
2013-08-09 12:30:00	SPY	ETF	169.31	169.56	169.305	169.41	3736479.0
2013-08-09 13:00:00	SPY	ETF	169.415	169.66	169.34	169.63	4137439.0
2013-08-09 13:30:00	SPY	ETF	169.64	169.7	169.5	169.5356	3661302.0
2013-08-09 14:00:00	SPY	ETF	169.53	169.61	169.33	169.53	3510614.0
2013-08-09 14:30:00	SPY	ETF	169.535	169.605	169.265	169.455	4300831.0
2013-08-09 15:00:00	SPY	ETF	169.455	169.555	169.33	169.4	3809230.0
2013-08-09 15:30:00	SPY	ETF	169.4	169.44	169.17	169.3	11923011.0
2013-08-09 16:00:00	SPY	ETF	169.31	169.4808	169.02	169.05	5029381.0
2013-08-09 16:30:00	SPY	ETF	169.05	169.07	169.0229	169.05	266760.0
2013-08-09 17:00:00	SPY	ETF	169.05	169.06	168.99	169.04	239503.0
2013-08-09 17:30:00	SPY	ETF	169.01	169.04	168.98	169.01	75934.0
2013-08-09 18:00:00	SPY	ETF	169.01	169.05	169.01	169.01	6739.0
2013-08-09 18:30:00	SPY	ETF	169.04	169.04	169.01	169.01	2400.0
2013-08-09 19:00:00	SPY	ETF	169.0	169.02	168.97	169.02	6583.0
2013-08-09 19:30:00	SPY	ETF	169.0	169.04	168.98	169.02	16580.0
2013-08-09 04:00:00	QQQ	ETF	76.71	76.71	76.6	76.6	20200.0
2013-08-09 04:30:00	QQQ	ETF	76.58	76.6	76.56	76.6	3600.0
2013-08-09 05:00:00	QQQ	ETF	76.62	76.68	76.62	76.64	5400.0
2013-08-09 05:30:00	QQQ	ETF	76.64	76.64	76.64	76.64	100.0
2013-08-09 06:00:00	QQQ	ETF	76.62	76.62	76.56	76.58	4400.0
2013-08-09 06:30:00	QQQ	ETF	76.56	76.64	76.56	76.64	3750.0
2013-08-09 07:00:00	QQQ	ETF	76.63	76.64	76.63	76.64	49000.0
2013-08-09 07:30:00	QQQ	ETF	76.65	76.68	76.65	76.68	2000.0
2013-08-09 08:00:00	QQQ	ETF	76.71	76.72	76.68	76.72	22330.0
2013-08-09 08:30:00	QQQ	ETF	76.72	76.72	76.65	76.66	170844.0
2013-08-09 09:00:00	QQQ	ETF	76.66	76.76	76.66	76.7	351613.0
2013-08-09 09:30:00	QQQ	ETF	76.7	76.94	76.63	76.87	2360810.0
2013-08-09 10:00:00	QQQ	ETF	76.88	76.91	76.61	76.73	1872591.0
2013-08-09 10:30:00	QQQ	ETF	76.72	76.81	76.58	76.62	1168615.0
2013-08-09 11:00:00	QQQ	ETF	76.615	76.615	76.27	76.33	2187475.0
2013-08-09 11:30:00	QQQ	ETF	76.34	76.52	76.31	76.5	1029423.0
2013-08-09 12:00:00	QQQ	ETF	76.49	76.64	76.46	76.631	641640.0
2013-08-09 12:30:00	QQQ	ETF	76.64	76.75	76.639	76.6527	982622.0

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

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