PREVIEW / etf_30min / 2010-06-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-22.parquet
  size:    254 KB
  rows:    8,400

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
2010-06-22 04:00:00	SPY	ETF	111.73	111.73	111.57	111.57	1744.0
2010-06-22 04:30:00	SPY	ETF	111.66	111.66	111.66	111.66	1500.0
2010-06-22 05:00:00	SPY	ETF	111.55	111.55	111.01	111.06	38850.0
2010-06-22 05:30:00	SPY	ETF	111.1	111.1	111.1	111.1	500.0
2010-06-22 06:00:00	SPY	ETF	110.91	111.64	110.91	111.64	2548.0
2010-06-22 06:30:00	SPY	ETF	111.1	111.27	111.03	111.05	25770.0
2010-06-22 07:00:00	SPY	ETF	111.05	111.25	111.03	111.17	668142.0
2010-06-22 07:30:00	SPY	ETF	111.17	111.31	111.04	111.13	590822.0
2010-06-22 08:00:00	SPY	ETF	111.14	111.28	110.99	111.24	1710570.0
2010-06-22 08:30:00	SPY	ETF	111.23	111.45	110.83	111.45	611511.0
2010-06-22 09:00:00	SPY	ETF	111.45	111.51	111.36	111.42	1503847.0
2010-06-22 09:30:00	SPY	ETF	111.41	111.9	111.33	111.51	20266928.0
2010-06-22 10:00:00	SPY	ETF	111.51	111.62	110.96	111.23	23392056.0
2010-06-22 10:30:00	SPY	ETF	111.22	111.41	110.91	111.31	14596723.0
2010-06-22 11:00:00	SPY	ETF	111.32	111.34	110.99	111.34	13093276.0
2010-06-22 11:30:00	SPY	ETF	111.34	111.71	111.29	111.4522	11541374.0
2010-06-22 12:00:00	SPY	ETF	111.46	111.53	111.29	111.29	6292865.0
2010-06-22 12:30:00	SPY	ETF	111.28	111.33	111.13	111.28	4871736.0
2010-06-22 13:00:00	SPY	ETF	111.28	111.41	111.05	111.1	7229698.0
2010-06-22 13:30:00	SPY	ETF	111.1	111.39	110.94	111.07	12753802.0
2010-06-22 14:00:00	SPY	ETF	111.07	111.08	110.55	110.7	14597673.0
2010-06-22 14:30:00	SPY	ETF	110.69	110.84	109.76	110.0	28430495.0
2010-06-22 15:00:00	SPY	ETF	110.0001	110.24	109.74	109.8	22450469.0
2010-06-22 15:30:00	SPY	ETF	109.79	111.0	109.41	109.57	32497960.0
2010-06-22 16:00:00	SPY	ETF	109.59	111.79	109.42	109.54	11152935.0
2010-06-22 16:30:00	SPY	ETF	109.54	109.74	109.53	109.65	395014.0
2010-06-22 17:00:00	SPY	ETF	109.67	111.33	109.58	109.65	206724.0
2010-06-22 17:30:00	SPY	ETF	109.65	111.3346	109.58	109.62	374380.0
2010-06-22 18:00:00	SPY	ETF	109.62	109.68	109.57	109.63	171615.0
2010-06-22 18:30:00	SPY	ETF	109.65	109.7	109.63	109.67	43220.0
2010-06-22 19:00:00	SPY	ETF	109.65	109.77	109.65	109.74	46900.0
2010-06-22 19:30:00	SPY	ETF	109.74	109.74	109.61	109.64	38866.0
2010-06-22 05:30:00	QQQ	ETF	46.56	46.56	46.56	46.56	400.0
2010-06-22 06:00:00	QQQ	ETF	46.47	46.56	46.47	46.56	17795.0
2010-06-22 06:30:00	QQQ	ETF	46.56	46.6	46.56	46.6	600.0
2010-06-22 07:00:00	QQQ	ETF	46.59	46.68	46.58	46.65	220736.0
2010-06-22 07:30:00	QQQ	ETF	46.64	46.7	46.58	46.61	58444.0
2010-06-22 08:00:00	QQQ	ETF	46.66	46.69	46.56	46.66	788682.0
2010-06-22 08:30:00	QQQ	ETF	46.66	46.76	46.65	46.76	218714.0
2010-06-22 09:00:00	QQQ	ETF	46.76	46.82	46.73	46.79	1480179.0
2010-06-22 09:30:00	QQQ	ETF	46.79	47.14	46.79	46.91	11333203.0
2010-06-22 10:00:00	QQQ	ETF	46.91	46.93	46.63	46.79	10415663.0
2010-06-22 10:30:00	QQQ	ETF	46.8	46.99	46.64	46.93	8364922.0
2010-06-22 11:00:00	QQQ	ETF	46.93	46.94	46.74	46.92	5952318.0
2010-06-22 11:30:00	QQQ	ETF	46.92	47.1	46.9	46.9704	4370349.0
2010-06-22 12:00:00	QQQ	ETF	46.97	47.03	46.91	46.92	2992248.0
2010-06-22 12:30:00	QQQ	ETF	46.92	46.94	46.87	46.92	2305853.0
2010-06-22 13:00:00	QQQ	ETF	46.92	47.0	46.83	46.85	2315157.0
2010-06-22 13:30:00	QQQ	ETF	46.85	46.96	46.75	46.82	3379552.0
2010-06-22 14:00:00	QQQ	ETF	46.81	46.82	46.57	46.6138	5816565.0

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

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