PREVIEW / etf_30min / 2010-07-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-08.parquet
  size:    247 KB
  rows:    8,349

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-08 04:00:00	SPY	ETF	106.2	106.2	106.04	106.06	5000.0
2010-07-08 04:30:00	SPY	ETF	106.19	106.19	106.11	106.11	245.0
2010-07-08 05:00:00	SPY	ETF	106.09	106.34	106.08	106.34	9535.0
2010-07-08 05:30:00	SPY	ETF	106.17	106.19	106.17	106.19	2000.0
2010-07-08 06:00:00	SPY	ETF	106.2	106.22	106.15	106.18	6270.0
2010-07-08 06:30:00	SPY	ETF	106.26	106.34	106.25	106.34	7150.0
2010-07-08 07:00:00	SPY	ETF	106.33	106.43	106.25	106.26	274173.0
2010-07-08 07:30:00	SPY	ETF	106.26	106.31	106.16	106.31	114491.0
2010-07-08 08:00:00	SPY	ETF	106.32	106.51	106.23	106.48	1421697.0
2010-07-08 08:30:00	SPY	ETF	106.47	107.05	106.0	106.89	5787092.0
2010-07-08 09:00:00	SPY	ETF	106.9	107.11	106.1075	106.99	2687883.0
2010-07-08 09:30:00	SPY	ETF	107.0	107.28	106.57	106.77	30376412.0
2010-07-08 10:00:00	SPY	ETF	106.76	106.96	106.49	106.9301	19841214.0
2010-07-08 10:30:00	SPY	ETF	106.93	106.95	106.45	106.5	13438671.0
2010-07-08 11:00:00	SPY	ETF	106.5	106.61	106.21	106.38	15850894.0
2010-07-08 11:30:00	SPY	ETF	106.38	106.55	106.04	106.18	10822899.0
2010-07-08 12:00:00	SPY	ETF	106.18	106.5	106.09	106.41	9206154.0
2010-07-08 12:30:00	SPY	ETF	106.41	106.44	106.2	106.27	7281822.0
2010-07-08 13:00:00	SPY	ETF	106.2699	106.71	106.24	106.48	8444581.0
2010-07-08 13:30:00	SPY	ETF	106.48	106.615	106.27	106.36	5717394.0
2010-07-08 14:00:00	SPY	ETF	106.35	106.42	105.91	106.125	11902763.0
2010-07-08 14:30:00	SPY	ETF	106.16	106.56	106.1	106.5	8786372.0
2010-07-08 15:00:00	SPY	ETF	106.48	106.77	106.19	106.76	13788773.0
2010-07-08 15:30:00	SPY	ETF	106.76	107.17	106.65	107.15	34368690.0
2010-07-08 16:00:00	SPY	ETF	107.14	107.37	106.19	107.16	9014353.0
2010-07-08 16:30:00	SPY	ETF	107.18	107.19	107.13	107.13	343181.0
2010-07-08 17:00:00	SPY	ETF	107.13	107.22	107.08	107.18	410285.0
2010-07-08 17:30:00	SPY	ETF	107.17	107.22	107.13	107.13	80812.0
2010-07-08 18:00:00	SPY	ETF	107.16	107.18	107.06	107.06	78789.0
2010-07-08 18:30:00	SPY	ETF	107.09	107.09	107.06	107.08	14340.0
2010-07-08 19:00:00	SPY	ETF	107.14	107.14	107.08	107.12	8350.0
2010-07-08 19:30:00	SPY	ETF	107.13	107.14	106.95	107.05	83032.0
2010-07-08 04:30:00	QQQ	ETF	43.9	43.9	43.9	43.9	200.0
2010-07-08 06:00:00	QQQ	ETF	43.93	43.93	43.92	43.92	200.0
2010-07-08 06:30:00	QQQ	ETF	43.95	43.97	43.95	43.97	443.0
2010-07-08 07:00:00	QQQ	ETF	44.0	44.0	43.96	43.96	3100.0
2010-07-08 07:30:00	QQQ	ETF	43.95	43.96	43.91	43.96	5100.0
2010-07-08 08:00:00	QQQ	ETF	43.98	44.03	43.97	44.02	81719.0
2010-07-08 08:30:00	QQQ	ETF	44.01	44.26	44.01	44.23	1292945.0
2010-07-08 09:00:00	QQQ	ETF	44.22	44.33	43.99	44.3	861646.0
2010-07-08 09:30:00	QQQ	ETF	44.3	44.38	44.07	44.19	11751846.0
2010-07-08 10:00:00	QQQ	ETF	44.185	44.32	44.08	44.31	5274622.0
2010-07-08 10:30:00	QQQ	ETF	44.31	44.3201	44.12	44.14	3773357.0
2010-07-08 11:00:00	QQQ	ETF	44.14	44.15	43.93	43.98	6372279.0
2010-07-08 11:30:00	QQQ	ETF	43.985	44.04	43.72	43.8	4347215.0
2010-07-08 12:00:00	QQQ	ETF	43.81	43.98	43.77	43.93	3061406.0
2010-07-08 12:30:00	QQQ	ETF	43.93	43.94	43.76	43.8	2069957.0
2010-07-08 13:00:00	QQQ	ETF	43.8	44.03	43.79	43.92	2484551.0
2010-07-08 13:30:00	QQQ	ETF	43.93	44.02	43.83	43.88	2410805.0
2010-07-08 14:00:00	QQQ	ETF	43.8899	43.94	43.68	43.82	4980841.0

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

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