PREVIEW / etf_30min / 2012-03-01

all etf 30-min files

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

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-01 04:00:00	SPY	ETF	136.98	136.98	136.81	136.98	1908.0
2012-03-01 04:30:00	SPY	ETF	137.03	137.1	136.98	137.06	61450.0
2012-03-01 05:00:00	SPY	ETF	136.98	137.16	136.96	137.16	23830.0
2012-03-01 05:30:00	SPY	ETF	136.98	137.08	136.95	137.02	24650.0
2012-03-01 06:00:00	SPY	ETF	137.08	137.11	137.02	137.11	67900.0
2012-03-01 06:30:00	SPY	ETF	137.12	137.31	137.12	137.31	110588.0
2012-03-01 07:00:00	SPY	ETF	137.25	137.34	137.17	137.17	188865.0
2012-03-01 07:30:00	SPY	ETF	137.2	137.26	137.07	137.26	179448.0
2012-03-01 08:00:00	SPY	ETF	137.2	137.4	137.2	137.36	784198.0
2012-03-01 08:30:00	SPY	ETF	137.36	137.38	137.22	137.29	1658284.0
2012-03-01 09:00:00	SPY	ETF	137.29	137.4	136.87	137.3	1009616.0
2012-03-01 09:30:00	SPY	ETF	137.31	137.82	137.27	137.78	17336276.0
2012-03-01 10:00:00	SPY	ETF	137.78	137.78	137.12	137.59	20830853.0
2012-03-01 10:30:00	SPY	ETF	137.58	137.611	137.23	137.47	12207245.0
2012-03-01 11:00:00	SPY	ETF	137.47	137.58	137.34	137.55	9170178.0
2012-03-01 11:30:00	SPY	ETF	137.559	137.76	137.47	137.7	6611459.0
2012-03-01 12:00:00	SPY	ETF	137.69	137.86	137.61	137.74	4733668.0
2012-03-01 12:30:00	SPY	ETF	137.74	137.83	137.69	137.75	3416918.0
2012-03-01 13:00:00	SPY	ETF	137.75	137.96	137.68	137.95	8396267.0
2012-03-01 13:30:00	SPY	ETF	137.95	137.99	137.87	137.91	5332187.0
2012-03-01 14:00:00	SPY	ETF	137.91	137.99	137.725	137.7737	3618937.0
2012-03-01 14:30:00	SPY	ETF	137.775	137.82	137.67	137.78	3822308.0
2012-03-01 15:00:00	SPY	ETF	137.77	137.85	137.3	137.58	13911625.0
2012-03-01 15:30:00	SPY	ETF	137.58	137.87	137.27	137.73	22130460.0
2012-03-01 16:00:00	SPY	ETF	137.72	137.94	137.4707	137.93	7858207.0
2012-03-01 16:30:00	SPY	ETF	137.94	138.2	137.93	137.99	522411.0
2012-03-01 17:00:00	SPY	ETF	137.98	138.06	137.96	138.06	306924.0
2012-03-01 17:30:00	SPY	ETF	138.06	138.06	138.0	138.04	20700.0
2012-03-01 18:00:00	SPY	ETF	138.03	138.08	138.03	138.06	65937.0
2012-03-01 18:30:00	SPY	ETF	138.07	138.13	138.04	138.13	50737.0
2012-03-01 19:00:00	SPY	ETF	138.13	138.17	138.11	138.16	76886.0
2012-03-01 19:30:00	SPY	ETF	138.16	138.16	138.05	138.07	89872.0
2012-03-01 06:00:00	QQQ	ETF	64.6	64.6	64.59	64.59	1500.0
2012-03-01 06:30:00	QQQ	ETF	64.6	64.7	64.6	64.7	27720.0
2012-03-01 07:00:00	QQQ	ETF	64.68	64.69	64.66	64.68	58308.0
2012-03-01 07:30:00	QQQ	ETF	64.64	64.66	64.59	64.65	107600.0
2012-03-01 08:00:00	QQQ	ETF	64.65	64.73	64.65	64.7	147743.0
2012-03-01 08:30:00	QQQ	ETF	64.7	64.71	64.63	64.66	691661.0
2012-03-01 09:00:00	QQQ	ETF	64.67	64.72	64.63	64.64	560179.0
2012-03-01 09:30:00	QQQ	ETF	64.66	64.83	64.52	64.78	7245138.0
2012-03-01 10:00:00	QQQ	ETF	64.78	64.78	64.51	64.67	11378649.0
2012-03-01 10:30:00	QQQ	ETF	64.66	64.69	64.46	64.58	7548203.0
2012-03-01 11:00:00	QQQ	ETF	64.58	64.67	64.53	64.65	3761451.0
2012-03-01 11:30:00	QQQ	ETF	64.66	64.82	64.61	64.79	2947018.0
2012-03-01 12:00:00	QQQ	ETF	64.78	64.85	64.7399	64.8	2299448.0
2012-03-01 12:30:00	QQQ	ETF	64.8	64.86	64.78	64.838	1036171.0
2012-03-01 13:00:00	QQQ	ETF	64.84	64.96	64.7993	64.92	3392258.0
2012-03-01 13:30:00	QQQ	ETF	64.92	64.97	64.9	64.93	1478443.0
2012-03-01 14:00:00	QQQ	ETF	64.935	64.98	64.87	64.9	1662541.0
2012-03-01 14:30:00	QQQ	ETF	64.9	64.94	64.86	64.91	1762029.0

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

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