PREVIEW / etf_30min / 2012-03-08

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-08.parquet
  size:    290 KB
  rows:    9,748

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-08 04:00:00	SPY	ETF	136.15	136.65	136.15	136.64	32052.0
2012-03-08 04:30:00	SPY	ETF	136.63	136.79	136.63	136.72	61325.0
2012-03-08 05:00:00	SPY	ETF	136.7	136.84	136.67	136.84	8950.0
2012-03-08 05:30:00	SPY	ETF	136.78	136.89	136.74	136.88	60539.0
2012-03-08 06:00:00	SPY	ETF	136.95	137.03	136.88	136.93	31035.0
2012-03-08 06:30:00	SPY	ETF	136.92	137.02	136.88	137.0	221140.0
2012-03-08 07:00:00	SPY	ETF	137.0	137.05	136.9	136.95	893202.0
2012-03-08 07:30:00	SPY	ETF	136.93	136.95	136.79	136.83	618708.0
2012-03-08 08:00:00	SPY	ETF	136.86	136.96	136.75	136.78	1327614.0
2012-03-08 08:30:00	SPY	ETF	136.75	136.87	136.59	136.61	827078.0
2012-03-08 09:00:00	SPY	ETF	136.61	136.8257	136.5	136.52	1387764.0
2012-03-08 09:30:00	SPY	ETF	136.52	136.76	136.42	136.5	13226174.0
2012-03-08 10:00:00	SPY	ETF	136.49	136.56	136.24	136.34	9298538.0
2012-03-08 10:30:00	SPY	ETF	136.33	136.59	136.31	136.57	8188311.0
2012-03-08 11:00:00	SPY	ETF	136.58	136.81	136.55	136.72	9282795.0
2012-03-08 11:30:00	SPY	ETF	136.72	136.8	136.69	136.79	4774678.0
2012-03-08 12:00:00	SPY	ETF	136.79	136.94	136.77	136.9	5583069.0
2012-03-08 12:30:00	SPY	ETF	136.9	137.02	136.89	136.98	3786508.0
2012-03-08 13:00:00	SPY	ETF	136.985	137.0	136.88	136.915	4251848.0
2012-03-08 13:30:00	SPY	ETF	136.92	136.99	136.85	136.86	3660080.0
2012-03-08 14:00:00	SPY	ETF	136.86	136.91	136.8	136.85	4083630.0
2012-03-08 14:30:00	SPY	ETF	136.86	137.25	136.8	137.1901	8945674.0
2012-03-08 15:00:00	SPY	ETF	137.2	137.32	137.13	137.2	8421535.0
2012-03-08 15:30:00	SPY	ETF	137.21	137.24	137.0	137.02	14360696.0
2012-03-08 16:00:00	SPY	ETF	137.02	137.19	136.0246	137.11	9735806.0
2012-03-08 16:30:00	SPY	ETF	137.1	137.12	136.0246	137.04	587894.0
2012-03-08 17:00:00	SPY	ETF	137.03	137.12	137.01	137.11	347550.0
2012-03-08 17:30:00	SPY	ETF	137.1	137.12	137.06	137.07	55528.0
2012-03-08 18:00:00	SPY	ETF	137.07	137.18	137.02	137.08	78196.0
2012-03-08 18:30:00	SPY	ETF	137.08	137.11	137.06	137.09	20011.0
2012-03-08 19:00:00	SPY	ETF	137.1	137.1	137.01	137.01	18968.0
2012-03-08 19:30:00	SPY	ETF	137.0	137.0	136.89	136.94	151585.0
2012-03-08 04:00:00	QQQ	ETF	64.35	64.42	64.35	64.42	200.0
2012-03-08 04:30:00	QQQ	ETF	64.46	64.5	64.45	64.48	1700.0
2012-03-08 05:30:00	QQQ	ETF	64.56	64.56	64.56	64.56	300.0
2012-03-08 06:00:00	QQQ	ETF	64.6	64.64	64.56	64.56	8330.0
2012-03-08 06:30:00	QQQ	ETF	64.53	64.56	64.53	64.54	900.0
2012-03-08 07:00:00	QQQ	ETF	64.56	64.58	64.54	64.54	246155.0
2012-03-08 07:30:00	QQQ	ETF	64.53	64.53	64.45	64.48	398906.0
2012-03-08 08:00:00	QQQ	ETF	64.47	64.54	64.46	64.46	933373.0
2012-03-08 08:30:00	QQQ	ETF	64.44	64.53	64.41	64.42	681927.0
2012-03-08 09:00:00	QQQ	ETF	64.43	64.46	64.37	64.42	326927.0
2012-03-08 09:30:00	QQQ	ETF	64.42	64.52	64.35	64.45	5815341.0
2012-03-08 10:00:00	QQQ	ETF	64.45	64.49	64.3	64.37	2866561.0
2012-03-08 10:30:00	QQQ	ETF	64.37	64.52	64.35	64.5	3059224.0
2012-03-08 11:00:00	QQQ	ETF	64.51	64.65	64.5	64.58	2558318.0
2012-03-08 11:30:00	QQQ	ETF	64.59	64.65	64.57	64.6299	2247012.0
2012-03-08 12:00:00	QQQ	ETF	64.622	64.72	64.61	64.7	1666600.0
2012-03-08 12:30:00	QQQ	ETF	64.7	64.77	64.68	64.7393	1318737.0
2012-03-08 13:00:00	QQQ	ETF	64.7379	64.79	64.69	64.745	1580008.0

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

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