PREVIEW / etf_30min / 2012-03-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-20.parquet
  size:    288 KB
  rows:    9,730

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-03-20 04:00:00	SPY	ETF	140.57	140.58	140.44	140.48	15282.0
2012-03-20 04:30:00	SPY	ETF	140.51	140.51	140.43	140.43	2100.0
2012-03-20 05:00:00	SPY	ETF	140.63	140.63	140.25	140.28	26350.0
2012-03-20 05:30:00	SPY	ETF	140.15	140.18	140.01	140.13	5897.0
2012-03-20 06:00:00	SPY	ETF	140.12	140.14	140.04	140.08	19500.0
2012-03-20 06:30:00	SPY	ETF	140.06	140.11	139.99	140.06	41055.0
2012-03-20 07:00:00	SPY	ETF	140.03	140.17	140.02	140.16	186940.0
2012-03-20 07:30:00	SPY	ETF	140.17	140.21	140.05	140.06	141010.0
2012-03-20 08:00:00	SPY	ETF	140.07	140.08	139.9	140.03	1261229.0
2012-03-20 08:30:00	SPY	ETF	140.03	140.13	139.97	140.02	1368243.0
2012-03-20 09:00:00	SPY	ETF	140.02	140.16	139.97	140.06	1032748.0
2012-03-20 09:30:00	SPY	ETF	140.05	140.1	139.64	139.955	20761207.0
2012-03-20 10:00:00	SPY	ETF	139.95	140.148	139.87	139.97	11208420.0
2012-03-20 10:30:00	SPY	ETF	139.98	140.25	139.93	140.12	8318093.0
2012-03-20 11:00:00	SPY	ETF	140.13	140.27	140.1	140.21	7684307.0
2012-03-20 11:30:00	SPY	ETF	140.215	140.23	139.96	140.109	8654190.0
2012-03-20 12:00:00	SPY	ETF	140.1	140.21	140.07	140.13	7039581.0
2012-03-20 12:30:00	SPY	ETF	140.13	140.24	140.1	140.21	3868875.0
2012-03-20 13:00:00	SPY	ETF	140.21	140.43	140.18	140.31	6036170.0
2012-03-20 13:30:00	SPY	ETF	140.31	140.42	140.22	140.4	4852723.0
2012-03-20 14:00:00	SPY	ETF	140.4	140.56	140.31	140.485	6719417.0
2012-03-20 14:30:00	SPY	ETF	140.47	140.5	140.39	140.4575	4108159.0
2012-03-20 15:00:00	SPY	ETF	140.46	140.61	140.46	140.525	6554606.0
2012-03-20 15:30:00	SPY	ETF	140.53	140.59	140.28	140.42	15877531.0
2012-03-20 16:00:00	SPY	ETF	140.42	140.47	139.91	140.44	3803635.0
2012-03-20 16:30:00	SPY	ETF	140.45	140.6	140.4284	140.54	664620.0
2012-03-20 17:00:00	SPY	ETF	140.54	140.55	140.47	140.5	63634.0
2012-03-20 17:30:00	SPY	ETF	140.54	140.54	140.47	140.49	12657.0
2012-03-20 18:00:00	SPY	ETF	140.5	140.51	140.45	140.47	24705.0
2012-03-20 18:30:00	SPY	ETF	140.48	140.48	140.44	140.45	11147.0
2012-03-20 19:00:00	SPY	ETF	140.45	140.47	140.35	140.43	48122.0
2012-03-20 19:30:00	SPY	ETF	140.45	140.45	140.43	140.45	18432.0
2012-03-20 05:00:00	QQQ	ETF	66.75	66.75	66.75	66.75	100.0
2012-03-20 05:30:00	QQQ	ETF	66.7	66.7	66.66	66.69	11003.0
2012-03-20 06:00:00	QQQ	ETF	66.71	66.71	66.65	66.67	17200.0
2012-03-20 06:30:00	QQQ	ETF	66.65	66.66	66.65	66.65	9100.0
2012-03-20 07:00:00	QQQ	ETF	66.67	66.72	66.66	66.72	12300.0
2012-03-20 07:30:00	QQQ	ETF	66.74	66.75	66.69	66.69	33900.0
2012-03-20 08:00:00	QQQ	ETF	66.68	66.73	66.62	66.68	1137682.0
2012-03-20 08:30:00	QQQ	ETF	66.67	66.69	66.64	66.65	99535.0
2012-03-20 09:00:00	QQQ	ETF	66.65	66.7	66.64	66.66	81250.0
2012-03-20 09:30:00	QQQ	ETF	66.65	66.68	66.46	66.54	5006946.0
2012-03-20 10:00:00	QQQ	ETF	66.55	66.67	66.47	66.6	3042178.0
2012-03-20 10:30:00	QQQ	ETF	66.6	66.68	66.57	66.63	1896366.0
2012-03-20 11:00:00	QQQ	ETF	66.62	66.75	66.595	66.7	2494121.0
2012-03-20 11:30:00	QQQ	ETF	66.698	66.71	66.55	66.65	1674959.0
2012-03-20 12:00:00	QQQ	ETF	66.64	66.71	66.61	66.6401	2613645.0
2012-03-20 12:30:00	QQQ	ETF	66.65	66.76	66.64	66.73	1732623.0
2012-03-20 13:00:00	QQQ	ETF	66.725	66.86	66.7	66.81	2898575.0
2012-03-20 13:30:00	QQQ	ETF	66.82	66.94	66.7699	66.92	1458405.0

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

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