PREVIEW / etf_30min / 2012-04-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-20.parquet
  size:    273 KB
  rows:    9,203

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-04-20 04:00:00	SPY	ETF	138.17	138.19	138.01	138.06	1300.0
2012-04-20 04:30:00	SPY	ETF	138.05	138.07	137.74	137.74	6850.0
2012-04-20 05:00:00	SPY	ETF	137.86	137.86	137.86	137.86	160.0
2012-04-20 05:30:00	SPY	ETF	137.88	137.88	137.88	137.88	500.0
2012-04-20 06:00:00	SPY	ETF	138.22	138.42	138.22	138.4	8200.0
2012-04-20 06:30:00	SPY	ETF	138.39	138.61	138.3	138.45	58200.0
2012-04-20 07:00:00	SPY	ETF	138.47	138.47	138.24	138.27	199080.0
2012-04-20 07:30:00	SPY	ETF	138.26	138.42	138.18	138.34	735418.0
2012-04-20 08:00:00	SPY	ETF	138.33	138.58	137.81	138.43	1260417.0
2012-04-20 08:30:00	SPY	ETF	138.44	138.51	138.29	138.36	647536.0
2012-04-20 09:00:00	SPY	ETF	138.35	138.49	138.31	138.33	932209.0
2012-04-20 09:30:00	SPY	ETF	138.33	138.53	138.14	138.53	24616714.0
2012-04-20 10:00:00	SPY	ETF	138.52	138.63	138.205	138.515	13566786.0
2012-04-20 10:30:00	SPY	ETF	138.52	138.83	138.52	138.68	12372574.0
2012-04-20 11:00:00	SPY	ETF	138.68	138.69	138.54	138.59	6021663.0
2012-04-20 11:30:00	SPY	ETF	138.59	138.69	138.55	138.68	5662766.0
2012-04-20 12:00:00	SPY	ETF	138.68	138.8	138.67	138.72	4306514.0
2012-04-20 12:30:00	SPY	ETF	138.72	138.75	138.6	138.62	3663412.0
2012-04-20 13:00:00	SPY	ETF	138.62	138.67	138.41	138.43	4037787.0
2012-04-20 13:30:00	SPY	ETF	138.44	138.45	138.18	138.269	5292138.0
2012-04-20 14:00:00	SPY	ETF	138.26	138.39	138.05	138.3586	9467723.0
2012-04-20 14:30:00	SPY	ETF	138.35	138.37	138.1	138.15	5876689.0
2012-04-20 15:00:00	SPY	ETF	138.15	138.17	137.91	138.01	10154492.0
2012-04-20 15:30:00	SPY	ETF	138.01	138.45	137.87	137.93	20438045.0
2012-04-20 16:00:00	SPY	ETF	137.94	138.3705	137.88	138.02	10819624.0
2012-04-20 16:30:00	SPY	ETF	138.02	138.0656	137.99	138.02	887451.0
2012-04-20 17:00:00	SPY	ETF	138.01	138.01	137.9248	137.99	598420.0
2012-04-20 17:30:00	SPY	ETF	137.99	138.0	137.97	137.99	128660.0
2012-04-20 18:00:00	SPY	ETF	137.99	137.99	137.85	137.86	86736.0
2012-04-20 18:30:00	SPY	ETF	137.88	137.89	137.87	137.87	11500.0
2012-04-20 19:00:00	SPY	ETF	137.86	137.87	137.76	137.76	59331.0
2012-04-20 19:30:00	SPY	ETF	137.75	137.8	137.46	137.46	174911.0
2012-04-20 05:00:00	QQQ	ETF	65.98	65.98	65.98	65.98	4000.0
2012-04-20 06:00:00	QQQ	ETF	66.23	66.24	66.23	66.24	300.0
2012-04-20 06:30:00	QQQ	ETF	66.13	66.21	66.13	66.21	1600.0
2012-04-20 07:00:00	QQQ	ETF	66.23	66.23	66.16	66.16	7800.0
2012-04-20 07:30:00	QQQ	ETF	66.12	66.22	66.11	66.18	93200.0
2012-04-20 08:00:00	QQQ	ETF	66.16	66.3	66.16	66.22	988602.0
2012-04-20 08:30:00	QQQ	ETF	66.22	66.24	66.13	66.16	83905.0
2012-04-20 09:00:00	QQQ	ETF	66.16	66.24	66.14	66.22	538806.0
2012-04-20 09:30:00	QQQ	ETF	66.21	66.43	65.98	66.43	11007676.0
2012-04-20 10:00:00	QQQ	ETF	66.43	66.48	66.24	66.35	4047444.0
2012-04-20 10:30:00	QQQ	ETF	66.36	66.51	66.33	66.362	4387865.0
2012-04-20 11:00:00	QQQ	ETF	66.36	66.37	66.26	66.31	1889951.0
2012-04-20 11:30:00	QQQ	ETF	66.31	66.35	66.22	66.33	1300803.0
2012-04-20 12:00:00	QQQ	ETF	66.3376	66.42	66.2801	66.29	1553548.0
2012-04-20 12:30:00	QQQ	ETF	66.29	66.34	66.2	66.21	1085620.0
2012-04-20 13:00:00	QQQ	ETF	66.21	66.26	66.025	66.03	1712128.0
2012-04-20 13:30:00	QQQ	ETF	66.04	66.07	65.89	65.97	3277223.0
2012-04-20 14:00:00	QQQ	ETF	65.97	66.015	65.8	65.99	4137246.0

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

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