PREVIEW / etf_30min / 2012-12-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-13.parquet
  size:    296 KB
  rows:    9,890

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-12-13 04:00:00	SPY	ETF	143.37	143.37	143.3	143.32	2900.0
2012-12-13 04:30:00	SPY	ETF	143.32	143.32	143.27	143.27	200.0
2012-12-13 05:00:00	SPY	ETF	143.2	143.21	143.11	143.11	24600.0
2012-12-13 05:30:00	SPY	ETF	143.07	143.28	143.07	143.28	22900.0
2012-12-13 06:00:00	SPY	ETF	143.25	143.31	143.21	143.21	11000.0
2012-12-13 06:30:00	SPY	ETF	143.21	143.31	143.16	143.31	31800.0
2012-12-13 07:00:00	SPY	ETF	143.29	143.41	143.29	143.4	83566.0
2012-12-13 07:30:00	SPY	ETF	143.39	143.39	143.25	143.35	77729.0
2012-12-13 08:00:00	SPY	ETF	143.35	143.55	143.24	143.55	170589.0
2012-12-13 08:30:00	SPY	ETF	143.55	143.81	143.29	143.35	667102.0
2012-12-13 09:00:00	SPY	ETF	143.36	143.51	143.36	143.43	854025.0
2012-12-13 09:30:00	SPY	ETF	143.42	143.63	143.27	143.53	9267053.0
2012-12-13 10:00:00	SPY	ETF	143.53	143.83	143.47	143.705	8159847.0
2012-12-13 10:30:00	SPY	ETF	143.7	143.75	143.45	143.46	6870965.0
2012-12-13 11:00:00	SPY	ETF	143.47	143.51	142.99	143.16	11540090.0
2012-12-13 11:30:00	SPY	ETF	143.155	143.34	143.03	143.19	7718628.0
2012-12-13 12:00:00	SPY	ETF	143.197	143.22	142.73	142.745	7657168.0
2012-12-13 12:30:00	SPY	ETF	142.75	142.84	142.57	142.699	7421499.0
2012-12-13 13:00:00	SPY	ETF	142.69	142.78	142.48	142.7599	6126164.0
2012-12-13 13:30:00	SPY	ETF	142.76	142.77	142.44	142.62	4556222.0
2012-12-13 14:00:00	SPY	ETF	142.62	142.65	142.275	142.54	9387412.0
2012-12-13 14:30:00	SPY	ETF	142.54	142.62	142.46	142.53	5193276.0
2012-12-13 15:00:00	SPY	ETF	142.52	142.59	142.325	142.46	6907305.0
2012-12-13 15:30:00	SPY	ETF	142.4599	143.0	142.44	142.69	21237309.0
2012-12-13 16:00:00	SPY	ETF	142.69	143.6866	142.46	142.57	10518374.0
2012-12-13 16:30:00	SPY	ETF	142.55	142.55	142.41	142.43	4900717.0
2012-12-13 17:00:00	SPY	ETF	142.44	142.45	142.34	142.35	2973735.0
2012-12-13 17:30:00	SPY	ETF	142.36	142.4	142.28	142.33	335487.0
2012-12-13 18:00:00	SPY	ETF	142.33	142.75	142.33	142.74	274690.0
2012-12-13 18:30:00	SPY	ETF	142.72	142.87	142.7	142.85	97730.0
2012-12-13 19:00:00	SPY	ETF	142.8	142.85	142.65	142.66	28864.0
2012-12-13 19:30:00	SPY	ETF	142.67	142.68	142.4	142.45	51151.0
2012-12-13 05:30:00	QQQ	ETF	65.63	65.63	65.63	65.63	100.0
2012-12-13 06:30:00	QQQ	ETF	65.68	65.68	65.68	65.68	4000.0
2012-12-13 07:30:00	QQQ	ETF	65.73	65.73	65.66	65.68	900.0
2012-12-13 08:00:00	QQQ	ETF	65.71	65.8	65.7	65.8	12090.0
2012-12-13 08:30:00	QQQ	ETF	65.82	65.9	65.62	65.65	237691.0
2012-12-13 09:00:00	QQQ	ETF	65.65	65.72	65.65	65.7	97198.0
2012-12-13 09:30:00	QQQ	ETF	65.71	65.9	65.63	65.74	3672648.0
2012-12-13 10:00:00	QQQ	ETF	65.74	66.16	65.68	66.092	3561529.0
2012-12-13 10:30:00	QQQ	ETF	66.1	66.14	65.89	65.94	2217964.0
2012-12-13 11:00:00	QQQ	ETF	65.94	65.97	65.51	65.61	3057633.0
2012-12-13 11:30:00	QQQ	ETF	65.61	65.73	65.49	65.6	2377475.0
2012-12-13 12:00:00	QQQ	ETF	65.6	65.62	65.24	65.25	3865281.0
2012-12-13 12:30:00	QQQ	ETF	65.24	65.28	65.15	65.2	4166848.0
2012-12-13 13:00:00	QQQ	ETF	65.1999	65.32	65.13	65.27	3021207.0
2012-12-13 13:30:00	QQQ	ETF	65.279	65.28	65.12	65.25	1328009.0
2012-12-13 14:00:00	QQQ	ETF	65.2501	65.27	65.03	65.15	1854955.0
2012-12-13 14:30:00	QQQ	ETF	65.151	65.239	65.1237	65.19	1146582.0
2012-12-13 15:00:00	QQQ	ETF	65.18	65.232	65.07	65.149	1435632.0

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

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