PREVIEW / etf_30min / 2011-07-26

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-26.parquet
  size:    276 KB
  rows:    9,214

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
2011-07-26 04:00:00	SPY	ETF	134.01	134.21	134.01	134.16	2095.0
2011-07-26 04:30:00	SPY	ETF	134.13	134.13	134.07	134.07	1025.0
2011-07-26 05:00:00	SPY	ETF	133.89	133.89	133.89	133.89	1100.0
2011-07-26 05:30:00	SPY	ETF	133.65	133.65	133.65	133.65	100.0
2011-07-26 06:00:00	SPY	ETF	133.8	133.86	133.8	133.86	1100.0
2011-07-26 06:30:00	SPY	ETF	133.89	134.1	133.77	134.08	12800.0
2011-07-26 07:00:00	SPY	ETF	134.13	134.21	134.06	134.15	1189836.0
2011-07-26 07:30:00	SPY	ETF	134.13	134.21	134.01	134.03	572608.0
2011-07-26 08:00:00	SPY	ETF	134.01	134.17	134.01	134.15	1804472.0
2011-07-26 08:30:00	SPY	ETF	134.14	134.19	133.95	133.96	855955.0
2011-07-26 09:00:00	SPY	ETF	133.95	133.97	133.74	133.75	1686577.0
2011-07-26 09:30:00	SPY	ETF	133.74	133.91	133.1	133.25	18871578.0
2011-07-26 10:00:00	SPY	ETF	133.24	133.45	133.03	133.27	17469563.0
2011-07-26 10:30:00	SPY	ETF	133.27	133.6	133.19	133.484	8041586.0
2011-07-26 11:00:00	SPY	ETF	133.48	133.75	133.47	133.64	7174327.0
2011-07-26 11:30:00	SPY	ETF	133.64	133.67	133.45	133.53	4180882.0
2011-07-26 12:00:00	SPY	ETF	133.54	133.76	133.48	133.69	3060916.0
2011-07-26 12:30:00	SPY	ETF	133.69	133.725	133.5	133.6177	4970843.0
2011-07-26 13:00:00	SPY	ETF	133.62	133.68	133.4	133.495	5392777.0
2011-07-26 13:30:00	SPY	ETF	133.49	133.57	133.39	133.55	3504202.0
2011-07-26 14:00:00	SPY	ETF	133.56	133.96	133.51	133.83	9693500.0
2011-07-26 14:30:00	SPY	ETF	133.84	133.94	133.62	133.65	5671849.0
2011-07-26 15:00:00	SPY	ETF	133.65	133.73	133.5	133.59	7186603.0
2011-07-26 15:30:00	SPY	ETF	133.59	133.59	133.11	133.33	20504732.0
2011-07-26 16:00:00	SPY	ETF	133.33	133.4848	133.05	133.1	7028907.0
2011-07-26 16:30:00	SPY	ETF	133.08	133.13	133.04	133.1	504468.0
2011-07-26 17:00:00	SPY	ETF	133.09	133.15	133.05	133.07	164809.0
2011-07-26 17:30:00	SPY	ETF	133.07	133.14	132.98	133.0	361379.0
2011-07-26 18:00:00	SPY	ETF	133.01	133.36	132.98	133.03	172274.0
2011-07-26 18:30:00	SPY	ETF	133.02	133.14	133.01	133.14	71498.0
2011-07-26 19:00:00	SPY	ETF	133.13	133.16	133.06	133.13	24676.0
2011-07-26 19:30:00	SPY	ETF	133.14	133.14	133.08	133.1	22241.0
2011-07-26 04:00:00	QQQ	ETF	59.68	59.68	59.68	59.68	215.0
2011-07-26 07:00:00	QQQ	ETF	59.64	59.68	59.57	59.57	627500.0
2011-07-26 07:30:00	QQQ	ETF	59.6	59.64	59.59	59.6	92908.0
2011-07-26 08:00:00	QQQ	ETF	59.59	59.64	59.59	59.64	890190.0
2011-07-26 08:30:00	QQQ	ETF	59.67	59.68	59.56	59.56	138374.0
2011-07-26 09:00:00	QQQ	ETF	59.55	59.57	59.42	59.44	833080.0
2011-07-26 09:30:00	QQQ	ETF	59.44	59.73	59.37	59.41	6493257.0
2011-07-26 10:00:00	QQQ	ETF	59.45	59.53	59.32	59.47	5672653.0
2011-07-26 10:30:00	QQQ	ETF	59.46	59.63	59.4101	59.57	3331366.0
2011-07-26 11:00:00	QQQ	ETF	59.57	59.7	59.57	59.68	2161535.0
2011-07-26 11:30:00	QQQ	ETF	59.68	59.69	59.57	59.62	1148393.0
2011-07-26 12:00:00	QQQ	ETF	59.63	59.71	59.58	59.68	954797.0
2011-07-26 12:30:00	QQQ	ETF	59.67	59.72	59.61	59.7	2275609.0
2011-07-26 13:00:00	QQQ	ETF	59.7	59.73	59.57	59.62	1987858.0
2011-07-26 13:30:00	QQQ	ETF	59.62	59.67	59.58	59.6629	907326.0
2011-07-26 14:00:00	QQQ	ETF	59.66	59.83	59.63	59.76	1834234.0
2011-07-26 14:30:00	QQQ	ETF	59.77	59.83	59.71	59.72	1139284.0
2011-07-26 15:00:00	QQQ	ETF	59.7116	59.76	59.67	59.73	1772299.0

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

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