PREVIEW / etf_30min / 2012-08-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-24.parquet
  size:    277 KB
  rows:    9,311

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
2012-08-24 04:00:00	SPY	ETF	140.38	140.6	140.38	140.59	800.0
2012-08-24 04:30:00	SPY	ETF	140.5	140.5	140.5	140.5	100.0
2012-08-24 05:00:00	SPY	ETF	140.71	140.71	140.71	140.71	200.0
2012-08-24 05:30:00	SPY	ETF	140.66	140.66	140.66	140.66	950.0
2012-08-24 06:00:00	SPY	ETF	140.64	140.64	140.55	140.55	450.0
2012-08-24 06:30:00	SPY	ETF	140.54	140.54	140.48	140.54	1425.0
2012-08-24 07:00:00	SPY	ETF	140.5	140.59	140.27	140.33	35213.0
2012-08-24 07:30:00	SPY	ETF	140.31	140.42	140.3	140.39	224050.0
2012-08-24 08:00:00	SPY	ETF	140.41	140.6	140.36	140.53	304439.0
2012-08-24 08:30:00	SPY	ETF	140.5	140.57	140.17	140.24	1094394.0
2012-08-24 09:00:00	SPY	ETF	140.24	140.495	140.24	140.3	574823.0
2012-08-24 09:30:00	SPY	ETF	140.31	140.49	140.22	140.2699	9147896.0
2012-08-24 10:00:00	SPY	ETF	140.261	140.58	140.23	140.48	7173058.0
2012-08-24 10:30:00	SPY	ETF	140.4896	140.97	140.47	140.85	8228397.0
2012-08-24 11:00:00	SPY	ETF	140.859	141.43	140.84	141.29	12144656.0
2012-08-24 11:30:00	SPY	ETF	141.3	141.42	141.16	141.2	5994927.0
2012-08-24 12:00:00	SPY	ETF	141.2	141.39	141.16	141.37	3030889.0
2012-08-24 12:30:00	SPY	ETF	141.38	141.49	141.33	141.44	2918605.0
2012-08-24 13:00:00	SPY	ETF	141.4466	141.45	141.35	141.39	2361807.0
2012-08-24 13:30:00	SPY	ETF	141.39	141.72	141.38	141.58	6050813.0
2012-08-24 14:00:00	SPY	ETF	141.58	141.6	141.46	141.51	3138052.0
2012-08-24 14:30:00	SPY	ETF	141.52	141.53	141.34	141.38	2929014.0
2012-08-24 15:00:00	SPY	ETF	141.38	141.57	141.3	141.545	4253369.0
2012-08-24 15:30:00	SPY	ETF	141.54	141.83	141.39	141.52	17318811.0
2012-08-24 16:00:00	SPY	ETF	141.53	141.7	141.5	141.59	7090072.0
2012-08-24 16:30:00	SPY	ETF	141.58	141.58	140.6481	141.55	1311528.0
2012-08-24 17:00:00	SPY	ETF	141.58	141.58	141.52	141.57	22954.0
2012-08-24 17:30:00	SPY	ETF	141.55	141.59	141.55	141.55	12380.0
2012-08-24 18:00:00	SPY	ETF	141.57	141.57	141.52	141.52	14900.0
2012-08-24 18:30:00	SPY	ETF	141.52	141.63	141.52	141.63	20770.0
2012-08-24 19:00:00	SPY	ETF	141.63	141.63	141.59	141.63	5000.0
2012-08-24 19:30:00	SPY	ETF	141.63	141.66	141.62	141.66	24126.0
2012-08-24 05:00:00	QQQ	ETF	67.93	67.93	67.93	67.93	120.0
2012-08-24 06:00:00	QQQ	ETF	67.89	67.89	67.87	67.87	2400.0
2012-08-24 07:00:00	QQQ	ETF	67.82	67.9	67.77	67.79	36900.0
2012-08-24 07:30:00	QQQ	ETF	67.77	67.77	67.76	67.76	3100.0
2012-08-24 08:00:00	QQQ	ETF	67.8	67.92	67.76	67.9	209730.0
2012-08-24 08:30:00	QQQ	ETF	67.91	67.91	67.69	67.72	148945.0
2012-08-24 09:00:00	QQQ	ETF	67.73	67.81	67.7	67.71	107566.0
2012-08-24 09:30:00	QQQ	ETF	67.71	67.785	67.6	67.65	3127902.0
2012-08-24 10:00:00	QQQ	ETF	67.65	67.88	67.64	67.83	2358645.0
2012-08-24 10:30:00	QQQ	ETF	67.83	68.15	67.82	68.0801	3222228.0
2012-08-24 11:00:00	QQQ	ETF	68.09	68.33	68.04	68.24	4032419.0
2012-08-24 11:30:00	QQQ	ETF	68.24	68.31	68.13	68.19	1247296.0
2012-08-24 12:00:00	QQQ	ETF	68.19	68.29	68.15	68.28	1599544.0
2012-08-24 12:30:00	QQQ	ETF	68.28	68.35	68.23	68.34	1039362.0
2012-08-24 13:00:00	QQQ	ETF	68.34	68.34	68.24	68.25	462912.0
2012-08-24 13:30:00	QQQ	ETF	68.26	68.45	68.26	68.3427	1308837.0
2012-08-24 14:00:00	QQQ	ETF	68.35	68.36	68.25	68.32	1523591.0
2012-08-24 14:30:00	QQQ	ETF	68.31	68.32	68.23	68.25	478693.0

> showing 50 of 9,311 rows — these rows as CSV

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