PREVIEW / etf_30min / 2011-10-04

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-04.parquet
  size:    314 KB
  rows:    10,515

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-10-04 04:00:00	SPY	ETF	108.48	108.94	108.37	108.94	2730.0
2011-10-04 04:30:00	SPY	ETF	108.77	109.2	108.7	109.03	2334.0
2011-10-04 05:00:00	SPY	ETF	108.97	109.22	108.63	108.63	4200.0
2011-10-04 05:30:00	SPY	ETF	108.74	109.2	108.72	109.1	12338.0
2011-10-04 06:00:00	SPY	ETF	108.89	109.2	108.78	108.8	46335.0
2011-10-04 06:30:00	SPY	ETF	108.83	108.92	108.35	108.38	155509.0
2011-10-04 07:00:00	SPY	ETF	108.35	108.67	108.35	108.49	555252.0
2011-10-04 07:30:00	SPY	ETF	108.54	108.63	107.95	108.03	946472.0
2011-10-04 08:00:00	SPY	ETF	108.04	110.0	107.83	108.1	2170414.0
2011-10-04 08:30:00	SPY	ETF	108.1	109.15	108.09	108.45	2862011.0
2011-10-04 09:00:00	SPY	ETF	108.45	108.65	108.16	108.34	2778177.0
2011-10-04 09:30:00	SPY	ETF	108.35	108.91	107.43	107.86	50751678.0
2011-10-04 10:00:00	SPY	ETF	107.87	108.89	107.48	108.179	58551912.0
2011-10-04 10:30:00	SPY	ETF	108.179	109.51	107.99	109.24	38231632.0
2011-10-04 11:00:00	SPY	ETF	109.25	109.94	108.94	109.31	30736902.0
2011-10-04 11:30:00	SPY	ETF	109.31	109.74	108.74	109.6	21261506.0
2011-10-04 12:00:00	SPY	ETF	109.59	110.35	109.59	109.8	28408419.0
2011-10-04 12:30:00	SPY	ETF	109.8	110.32	109.695	109.881	14946727.0
2011-10-04 13:00:00	SPY	ETF	109.89	110.05	109.25	109.36	17484283.0
2011-10-04 13:30:00	SPY	ETF	109.37	109.64	109.0	109.11	15059248.0
2011-10-04 14:00:00	SPY	ETF	109.11	109.53	108.46	108.91	19546235.0
2011-10-04 14:30:00	SPY	ETF	108.91	109.43	108.24	108.35	23705905.0
2011-10-04 15:00:00	SPY	ETF	108.3501	109.41	107.89	109.19	29370076.0
2011-10-04 15:30:00	SPY	ETF	109.18	112.58	109.15	112.32	71190823.0
2011-10-04 16:00:00	SPY	ETF	112.315	112.45	109.0	112.09	21707947.0
2011-10-04 16:30:00	SPY	ETF	112.07	112.399	108.6	111.9	4586017.0
2011-10-04 17:00:00	SPY	ETF	111.91	112.18	111.7946	112.11	575286.0
2011-10-04 17:30:00	SPY	ETF	112.1	112.2	112.06	112.06	81467.0
2011-10-04 18:00:00	SPY	ETF	112.06	112.13	111.84	112.0	412312.0
2011-10-04 18:30:00	SPY	ETF	112.0	112.29	112.0	112.22	183213.0
2011-10-04 19:00:00	SPY	ETF	112.21	112.36	112.17	112.27	250495.0
2011-10-04 19:30:00	SPY	ETF	112.25	112.3	112.17	112.18	157439.0
2011-10-04 04:00:00	QQQ	ETF	50.72	50.72	50.38	50.38	2575.0
2011-10-04 04:30:00	QQQ	ETF	50.55	50.55	50.55	50.55	200.0
2011-10-04 05:00:00	QQQ	ETF	50.66	50.66	50.61	50.61	1000.0
2011-10-04 06:30:00	QQQ	ETF	50.69	50.69	50.5	50.57	2875.0
2011-10-04 07:00:00	QQQ	ETF	50.53	50.59	50.5	50.55	14000.0
2011-10-04 07:30:00	QQQ	ETF	50.55	50.55	50.29	50.35	72720.0
2011-10-04 08:00:00	QQQ	ETF	50.34	50.6	50.25	50.4	534977.0
2011-10-04 08:30:00	QQQ	ETF	50.39	50.65	50.39	50.61	630367.0
2011-10-04 09:00:00	QQQ	ETF	50.61	50.67	50.5	50.6	756387.0
2011-10-04 09:30:00	QQQ	ETF	50.6	50.84	50.3	50.52	11486288.0
2011-10-04 10:00:00	QQQ	ETF	50.52	51.05	50.25	50.68	13351373.0
2011-10-04 10:30:00	QQQ	ETF	50.68	51.33	50.63	51.2405	8644978.0
2011-10-04 11:00:00	QQQ	ETF	51.25	51.63	51.12	51.38	9447948.0
2011-10-04 11:30:00	QQQ	ETF	51.37	51.61	51.12	51.54	5653730.0
2011-10-04 12:00:00	QQQ	ETF	51.541	51.9	51.541	51.6	6717664.0
2011-10-04 12:30:00	QQQ	ETF	51.6	51.81	51.42	51.47	4933833.0
2011-10-04 13:00:00	QQQ	ETF	51.462	51.58	51.14	51.25	4998790.0
2011-10-04 13:30:00	QQQ	ETF	51.25	51.32	50.92	50.94	7177769.0

> showing 50 of 10,515 rows — these rows as CSV

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