PREVIEW / etf_30min / 2011-03-09

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-09.parquet
  size:    265 KB
  rows:    8,871

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-03-09 04:00:00	SPY	ETF	132.25	132.58	132.25	132.58	1800.0
2011-03-09 04:30:00	SPY	ETF	132.65	132.65	132.52	132.55	400.0
2011-03-09 05:00:00	SPY	ETF	132.62	132.62	132.48	132.48	5200.0
2011-03-09 05:30:00	SPY	ETF	132.55	132.59	132.55	132.59	400.0
2011-03-09 06:00:00	SPY	ETF	132.69	132.71	132.68	132.68	30100.0
2011-03-09 06:30:00	SPY	ETF	132.83	132.93	132.75	132.77	16950.0
2011-03-09 07:00:00	SPY	ETF	132.73	132.84	132.54	132.59	106290.0
2011-03-09 07:30:00	SPY	ETF	132.63	132.77	132.48	132.74	314905.0
2011-03-09 08:00:00	SPY	ETF	132.72	132.76	132.53	132.58	376997.0
2011-03-09 08:30:00	SPY	ETF	132.56	132.59	132.32	132.36	974311.0
2011-03-09 09:00:00	SPY	ETF	132.35	132.4	132.21	132.3	2445921.0
2011-03-09 09:30:00	SPY	ETF	132.32	132.42	131.75	132.05	18472322.0
2011-03-09 10:00:00	SPY	ETF	132.04	132.6	131.79	132.55	13630401.0
2011-03-09 10:30:00	SPY	ETF	132.56	132.67	131.71	131.815	18368315.0
2011-03-09 11:00:00	SPY	ETF	131.8	132.26	131.6	132.015	12581620.0
2011-03-09 11:30:00	SPY	ETF	132.02	132.53	131.8	132.43	11383803.0
2011-03-09 12:00:00	SPY	ETF	132.44	132.8	132.33	132.38	10158710.0
2011-03-09 12:30:00	SPY	ETF	132.38	132.7	132.28	132.43	8878764.0
2011-03-09 13:00:00	SPY	ETF	132.43	132.6	132.24	132.515	6065410.0
2011-03-09 13:30:00	SPY	ETF	132.52	132.53	132.17	132.31	6932055.0
2011-03-09 14:00:00	SPY	ETF	132.31	132.59	132.3	132.35	6884605.0
2011-03-09 14:30:00	SPY	ETF	132.35	132.52	132.11	132.41	7765809.0
2011-03-09 15:00:00	SPY	ETF	132.4	132.59	132.35	132.44	5619634.0
2011-03-09 15:30:00	SPY	ETF	132.44	132.5	132.22	132.39	15588576.0
2011-03-09 16:00:00	SPY	ETF	132.39	132.62	131.97	132.08	6137782.0
2011-03-09 16:30:00	SPY	ETF	132.05	132.39	131.98	131.99	454540.0
2011-03-09 17:00:00	SPY	ETF	132.04	132.09	131.99	132.0	306676.0
2011-03-09 17:30:00	SPY	ETF	131.99	132.02	131.96	131.99	40802.0
2011-03-09 18:00:00	SPY	ETF	132.0	132.42	132.0	132.11	63323.0
2011-03-09 18:30:00	SPY	ETF	132.11	132.11	131.93	131.96	25395.0
2011-03-09 19:00:00	SPY	ETF	131.95	132.05	131.92	131.97	25585.0
2011-03-09 19:30:00	SPY	ETF	131.99	132.02	131.94	132.02	49168.0
2011-03-09 04:30:00	QQQ	ETF	57.35	57.35	57.3	57.32	4700.0
2011-03-09 05:00:00	QQQ	ETF	57.29	57.29	57.26	57.26	1100.0
2011-03-09 06:00:00	QQQ	ETF	57.39	57.39	57.39	57.39	116.0
2011-03-09 06:30:00	QQQ	ETF	57.4	57.5	57.4	57.43	10100.0
2011-03-09 07:00:00	QQQ	ETF	57.41	57.46	57.36	57.36	41459.0
2011-03-09 07:30:00	QQQ	ETF	57.35	57.42	57.27	57.42	36097.0
2011-03-09 08:00:00	QQQ	ETF	57.39	57.42	57.31	57.35	138508.0
2011-03-09 08:30:00	QQQ	ETF	57.34	57.35	57.21	57.25	251493.0
2011-03-09 09:00:00	QQQ	ETF	57.22	57.26	57.12	57.2	1147412.0
2011-03-09 09:30:00	QQQ	ETF	57.21	57.22	56.72	56.96	14433377.0
2011-03-09 10:00:00	QQQ	ETF	56.96	57.27	56.82	57.22	6157608.0
2011-03-09 10:30:00	QQQ	ETF	57.21	57.26	56.8	56.85	8534995.0
2011-03-09 11:00:00	QQQ	ETF	56.84	56.97	56.75	56.84	5354974.0
2011-03-09 11:30:00	QQQ	ETF	56.845	57.145	56.76	57.1	4735194.0
2011-03-09 12:00:00	QQQ	ETF	57.11	57.24	56.995	57.02	3517711.0
2011-03-09 12:30:00	QQQ	ETF	57.02	57.18	56.98	57.05	2048080.0
2011-03-09 13:00:00	QQQ	ETF	57.05	57.1	56.92	57.058	3038407.0
2011-03-09 13:30:00	QQQ	ETF	57.055	57.055	56.8512	56.9162	1756841.0

> showing 50 of 8,871 rows — these rows as CSV

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