PREVIEW / etf_30min / 2012-10-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-19.parquet
  size:    294 KB
  rows:    9,742

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
2012-10-19 04:00:00	SPY	ETF	145.51	145.51	145.48	145.48	1400.0
2012-10-19 04:30:00	SPY	ETF	145.49	145.49	145.44	145.44	11600.0
2012-10-19 05:00:00	SPY	ETF	145.52	145.58	145.52	145.58	10500.0
2012-10-19 05:30:00	SPY	ETF	145.58	145.63	145.51	145.51	5300.0
2012-10-19 06:00:00	SPY	ETF	145.51	145.52	145.34	145.37	37100.0
2012-10-19 06:30:00	SPY	ETF	145.36	145.45	145.33	145.41	58833.0
2012-10-19 07:00:00	SPY	ETF	145.44	145.46	145.3	145.35	64156.0
2012-10-19 07:30:00	SPY	ETF	145.38	145.45	145.36	145.45	69299.0
2012-10-19 08:00:00	SPY	ETF	145.43	145.45	145.3	145.32	583928.0
2012-10-19 08:30:00	SPY	ETF	145.35	145.86	145.35	145.43	719909.0
2012-10-19 09:00:00	SPY	ETF	145.42	145.56	145.38	145.56	1255769.0
2012-10-19 09:30:00	SPY	ETF	145.55	145.56	144.85	145.04	19527868.0
2012-10-19 10:00:00	SPY	ETF	145.04	145.12	144.78	144.965	10757039.0
2012-10-19 10:30:00	SPY	ETF	144.96	144.975	144.7	144.78	9265422.0
2012-10-19 11:00:00	SPY	ETF	144.78	144.81	144.2445	144.38	12975302.0
2012-10-19 11:30:00	SPY	ETF	144.38	144.45	144.0	144.16	10082449.0
2012-10-19 12:00:00	SPY	ETF	144.17	144.18	143.66	143.78	13486324.0
2012-10-19 12:30:00	SPY	ETF	143.78	144.01	143.75	143.84	5855669.0
2012-10-19 13:00:00	SPY	ETF	143.83	144.03	143.75	143.86	5769049.0
2012-10-19 13:30:00	SPY	ETF	143.861	143.87	143.3	143.43	11086099.0
2012-10-19 14:00:00	SPY	ETF	143.43	143.57	143.05	143.175	10048456.0
2012-10-19 14:30:00	SPY	ETF	143.18	143.43	143.05	143.41	10848914.0
2012-10-19 15:00:00	SPY	ETF	143.41	143.64	143.18	143.46	13828005.0
2012-10-19 15:30:00	SPY	ETF	143.46	143.71	143.33	143.35	27228935.0
2012-10-19 16:00:00	SPY	ETF	143.33	144.8	142.65	143.13	14080876.0
2012-10-19 16:30:00	SPY	ETF	143.12	143.13	143.04	143.08	3900654.0
2012-10-19 17:00:00	SPY	ETF	143.08	143.11	143.03	143.1	1732550.0
2012-10-19 17:30:00	SPY	ETF	143.09	143.12	143.09	143.11	187000.0
2012-10-19 18:00:00	SPY	ETF	143.12	143.2	143.08	143.14	145239.0
2012-10-19 18:30:00	SPY	ETF	143.1	143.11	143.06	143.07	6754.0
2012-10-19 19:00:00	SPY	ETF	143.1	143.14	143.08	143.13	11190.0
2012-10-19 19:30:00	SPY	ETF	143.09	143.13	143.06	143.1	22458.0
2012-10-19 04:00:00	QQQ	ETF	67.05	67.05	67.05	67.05	400.0
2012-10-19 05:30:00	QQQ	ETF	67.06	67.06	67.06	67.06	200.0
2012-10-19 06:00:00	QQQ	ETF	67.03	67.03	67.01	67.01	1500.0
2012-10-19 06:30:00	QQQ	ETF	67.0	67.02	67.0	67.0	16200.0
2012-10-19 07:00:00	QQQ	ETF	67.02	67.02	66.93	66.96	26400.0
2012-10-19 07:30:00	QQQ	ETF	66.95	67.04	66.94	67.04	54750.0
2012-10-19 08:00:00	QQQ	ETF	67.07	67.09	67.02	67.06	585028.0
2012-10-19 08:30:00	QQQ	ETF	67.07	67.1	67.05	67.07	339044.0
2012-10-19 09:00:00	QQQ	ETF	67.08	67.24	67.01	67.22	491680.0
2012-10-19 09:30:00	QQQ	ETF	67.21	67.27	66.73	66.925	5228026.0
2012-10-19 10:00:00	QQQ	ETF	66.92	66.95	66.66	66.765	2310113.0
2012-10-19 10:30:00	QQQ	ETF	66.76	66.77	66.51	66.579	2830586.0
2012-10-19 11:00:00	QQQ	ETF	66.58	66.61	66.1801	66.275	5943454.0
2012-10-19 11:30:00	QQQ	ETF	66.28	66.29	65.97	66.08	4081908.0
2012-10-19 12:00:00	QQQ	ETF	66.085	66.11	65.81	65.87	5235326.0
2012-10-19 12:30:00	QQQ	ETF	65.87	66.05	65.85	65.91	2365450.0
2012-10-19 13:00:00	QQQ	ETF	65.91	66.0381	65.84	65.9401	2113482.0
2012-10-19 13:30:00	QQQ	ETF	65.95	65.9582	65.69	65.77	2971653.0

> showing 50 of 9,742 rows — these rows as CSV

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