PREVIEW / etf_30min / 2010-07-06

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-06.parquet
  size:    262 KB
  rows:    8,691

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-07-06 04:00:00	SPY	ETF	102.7	102.75	102.67	102.74	4652.0
2010-07-06 04:30:00	SPY	ETF	102.72	102.85	102.72	102.79	4392.0
2010-07-06 05:00:00	SPY	ETF	102.83	102.83	102.83	102.83	100.0
2010-07-06 05:30:00	SPY	ETF	102.85	103.08	102.84	103.06	44700.0
2010-07-06 06:00:00	SPY	ETF	102.99	103.19	102.98	103.19	22300.0
2010-07-06 06:30:00	SPY	ETF	103.19	103.22	103.14	103.18	220250.0
2010-07-06 07:00:00	SPY	ETF	103.17	103.2	103.05	103.1	372790.0
2010-07-06 07:30:00	SPY	ETF	103.04	103.04	102.92	103.03	670463.0
2010-07-06 08:00:00	SPY	ETF	103.0	103.38	101.82	103.28	1769604.0
2010-07-06 08:30:00	SPY	ETF	103.28	103.46	101.57	103.42	2186499.0
2010-07-06 09:00:00	SPY	ETF	103.42	103.69	103.39	103.65	2015100.0
2010-07-06 09:30:00	SPY	ETF	103.64	103.91	103.41	103.74	24611808.0
2010-07-06 10:00:00	SPY	ETF	103.74	104.37	103.51	104.08	28847692.0
2010-07-06 10:30:00	SPY	ETF	104.08	104.23	103.95	103.96	12676021.0
2010-07-06 11:00:00	SPY	ETF	103.96	104.1399	103.65	103.68	14239395.0
2010-07-06 11:30:00	SPY	ETF	103.69	103.97	103.66	103.901	8051035.0
2010-07-06 12:00:00	SPY	ETF	103.9	104.05	103.43	103.55	10347792.0
2010-07-06 12:30:00	SPY	ETF	103.55	103.63	102.98	103.078	12158250.0
2010-07-06 13:00:00	SPY	ETF	103.09	103.31	102.9	103.18	11792544.0
2010-07-06 13:30:00	SPY	ETF	103.19	103.26	102.37	102.48	16872167.0
2010-07-06 14:00:00	SPY	ETF	102.48	102.74	102.1	102.56	16422166.0
2010-07-06 14:30:00	SPY	ETF	102.56	102.79	102.31	102.34	12820194.0
2010-07-06 15:00:00	SPY	ETF	102.3399	102.52	101.88	102.24	20205811.0
2010-07-06 15:30:00	SPY	ETF	102.24	102.91	102.17	102.87	33505989.0
2010-07-06 16:00:00	SPY	ETF	102.87	103.09	102.7131	102.96	13194941.0
2010-07-06 16:30:00	SPY	ETF	102.95	106.2033	102.777	103.0	6974631.0
2010-07-06 17:00:00	SPY	ETF	102.99	103.06	102.3359	103.04	1179819.0
2010-07-06 17:30:00	SPY	ETF	103.04	103.08	102.95	103.02	84940.0
2010-07-06 18:00:00	SPY	ETF	103.02	103.03	102.86	102.92	50963.0
2010-07-06 18:30:00	SPY	ETF	102.92	102.92	102.2	102.91	45106.0
2010-07-06 19:00:00	SPY	ETF	102.91	102.98	102.91	102.98	11149.0
2010-07-06 19:30:00	SPY	ETF	102.99	103.0	102.93	102.95	36791.0
2010-07-06 04:00:00	QQQ	ETF	42.76	42.76	42.76	42.76	1000.0
2010-07-06 04:30:00	QQQ	ETF	42.8	42.8	42.8	42.8	200.0
2010-07-06 05:00:00	QQQ	ETF	42.82	42.82	42.82	42.82	200.0
2010-07-06 05:30:00	QQQ	ETF	42.81	42.89	42.81	42.87	31700.0
2010-07-06 06:00:00	QQQ	ETF	42.93	42.97	42.89	42.97	900.0
2010-07-06 06:30:00	QQQ	ETF	42.99	43.04	42.98	43.03	35823.0
2010-07-06 07:00:00	QQQ	ETF	43.02	43.03	42.96	42.97	87567.0
2010-07-06 07:30:00	QQQ	ETF	42.97	42.97	42.9	42.97	302365.0
2010-07-06 08:00:00	QQQ	ETF	42.97	43.1	42.95	43.06	808183.0
2010-07-06 08:30:00	QQQ	ETF	43.05	43.1	43.03	43.1	605985.0
2010-07-06 09:00:00	QQQ	ETF	43.08	43.17	43.05	43.1	718461.0
2010-07-06 09:30:00	QQQ	ETF	43.09	43.2	42.96	43.08	10355291.0
2010-07-06 10:00:00	QQQ	ETF	43.08	43.37	42.97	43.27	8172493.0
2010-07-06 10:30:00	QQQ	ETF	43.27	43.36	43.21	43.22	3249473.0
2010-07-06 11:00:00	QQQ	ETF	43.21	43.27	43.07	43.1	4329810.0
2010-07-06 11:30:00	QQQ	ETF	43.09	43.21	43.07	43.16	3283812.0
2010-07-06 12:00:00	QQQ	ETF	43.16	43.22	42.93	42.96	4833620.0
2010-07-06 12:30:00	QQQ	ETF	42.96	42.98	42.67	42.73	6337065.0

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

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