PREVIEW / etf_30min / 2012-12-31

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-31.parquet
  size:    332 KB
  rows:    10,880

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-12-31 04:00:00	SPY	ETF	139.45	139.48	139.43	139.48	982.0
2012-12-31 04:30:00	SPY	ETF	139.48	139.48	139.24	139.24	2201.0
2012-12-31 05:00:00	SPY	ETF	139.14	139.15	139.1	139.1	3024.0
2012-12-31 05:30:00	SPY	ETF	139.1	139.15	139.1	139.15	4085.0
2012-12-31 06:00:00	SPY	ETF	139.18	139.32	139.18	139.31	2271.0
2012-12-31 06:30:00	SPY	ETF	139.35	139.35	139.25	139.34	2245.0
2012-12-31 07:00:00	SPY	ETF	139.3	139.3	138.95	138.95	45963.0
2012-12-31 07:30:00	SPY	ETF	138.95	139.2	138.8	139.19	230880.0
2012-12-31 08:00:00	SPY	ETF	139.19	139.41	138.95	139.38	493286.0
2012-12-31 08:30:00	SPY	ETF	139.36	140.04	139.35	139.86	1857756.0
2012-12-31 09:00:00	SPY	ETF	139.88	139.95	139.6	139.66	1558770.0
2012-12-31 09:30:00	SPY	ETF	139.66	140.56	139.54	140.43	21593711.0
2012-12-31 10:00:00	SPY	ETF	140.42	140.69	140.18	140.413	16444956.0
2012-12-31 10:30:00	SPY	ETF	140.42	140.74	140.17	140.29	12893829.0
2012-12-31 11:00:00	SPY	ETF	140.29	140.73	140.23	140.3	12646261.0
2012-12-31 11:30:00	SPY	ETF	140.3	140.5	140.28	140.359	7810870.0
2012-12-31 12:00:00	SPY	ETF	140.37	140.48	140.33	140.45	6345395.0
2012-12-31 12:30:00	SPY	ETF	140.46	141.45	140.45	140.97	19005493.0
2012-12-31 13:00:00	SPY	ETF	140.97	141.32	140.63	141.09	14100998.0
2012-12-31 13:30:00	SPY	ETF	141.1	141.64	140.63	140.92	22054235.0
2012-12-31 14:00:00	SPY	ETF	140.93	141.36	140.85	141.35	7443240.0
2012-12-31 14:30:00	SPY	ETF	141.36	142.1399	141.25	142.029	13205307.0
2012-12-31 15:00:00	SPY	ETF	142.03	142.29	141.41	141.59	18132376.0
2012-12-31 15:30:00	SPY	ETF	141.59	142.56	141.585	142.46	39571803.0
2012-12-31 16:00:00	SPY	ETF	142.45	142.82	140.0259	142.53	17403590.0
2012-12-31 16:30:00	SPY	ETF	142.53	142.59	140.0263	142.59	6285757.0
2012-12-31 17:00:00	SPY	ETF	142.59	142.69	142.52	142.63	448617.0
2012-12-31 17:30:00	SPY	ETF	142.65	142.82	142.65	142.8	226136.0
2012-12-31 18:00:00	SPY	ETF	142.82	142.88	142.65	142.72	347813.0
2012-12-31 18:30:00	SPY	ETF	142.7	142.74	142.48	142.48	152450.0
2012-12-31 19:00:00	SPY	ETF	142.53	142.6	142.53	142.54	12118.0
2012-12-31 19:30:00	SPY	ETF	142.53	142.6	142.48	142.55	70285.0
2012-12-31 06:00:00	QQQ	ETF	63.46	63.46	63.46	63.46	300.0
2012-12-31 07:00:00	QQQ	ETF	63.46	63.46	63.33	63.33	1587.0
2012-12-31 07:30:00	QQQ	ETF	63.36	63.4	63.31	63.37	71325.0
2012-12-31 08:00:00	QQQ	ETF	63.41	63.5	63.38	63.49	58911.0
2012-12-31 08:30:00	QQQ	ETF	63.49	63.84	63.49	63.8	225130.0
2012-12-31 09:00:00	QQQ	ETF	63.82	63.82	63.65	63.67	617403.0
2012-12-31 09:30:00	QQQ	ETF	63.68	64.35	63.58	64.28	5911858.0
2012-12-31 10:00:00	QQQ	ETF	64.28	64.43	64.17	64.31	3554824.0
2012-12-31 10:30:00	QQQ	ETF	64.31	64.45	64.15	64.19	2812780.0
2012-12-31 11:00:00	QQQ	ETF	64.19	64.39	64.11	64.18	2461042.0
2012-12-31 11:30:00	QQQ	ETF	64.17	64.27	64.15	64.2299	1596270.0
2012-12-31 12:00:00	QQQ	ETF	64.225	64.29	64.15	64.28	888044.0
2012-12-31 12:30:00	QQQ	ETF	64.28	64.74	64.28	64.51	5232031.0
2012-12-31 13:00:00	QQQ	ETF	64.51	64.7118	64.35	64.61	3152169.0
2012-12-31 13:30:00	QQQ	ETF	64.61	64.83	64.38	64.49	5090904.0
2012-12-31 14:00:00	QQQ	ETF	64.49	64.75	64.45	64.74	1246929.0
2012-12-31 14:30:00	QQQ	ETF	64.74	65.22	64.69	65.14	4549851.0
2012-12-31 15:00:00	QQQ	ETF	65.1313	65.2521	64.82	64.84	5087828.0

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

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