PREVIEW / etf_30min / 2011-12-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-29.parquet
  size:    282 KB
  rows:    9,521

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
2011-12-29 04:00:00	SPY	ETF	124.98	124.98	124.85	124.85	641.0
2011-12-29 04:30:00	SPY	ETF	124.8	125.12	124.8	125.12	700.0
2011-12-29 05:00:00	SPY	ETF	125.14	125.14	125.14	125.14	300.0
2011-12-29 05:30:00	SPY	ETF	125.03	125.09	124.97	125.08	5600.0
2011-12-29 06:00:00	SPY	ETF	125.07	125.26	125.07	125.26	39650.0
2011-12-29 06:30:00	SPY	ETF	125.28	125.3	125.09	125.09	40800.0
2011-12-29 07:00:00	SPY	ETF	125.09	125.22	125.03	125.22	128314.0
2011-12-29 07:30:00	SPY	ETF	125.24	125.32	125.18	125.32	53026.0
2011-12-29 08:00:00	SPY	ETF	125.25	125.38	125.14	125.2	340855.0
2011-12-29 08:30:00	SPY	ETF	125.2	125.31	125.1	125.26	577651.0
2011-12-29 09:00:00	SPY	ETF	125.25	125.27	125.13	125.24	1006752.0
2011-12-29 09:30:00	SPY	ETF	125.24	125.58	125.18	125.44	16249467.0
2011-12-29 10:00:00	SPY	ETF	125.4399	125.76	125.41	125.7	11135840.0
2011-12-29 10:30:00	SPY	ETF	125.7	125.9	125.6991	125.811	6631925.0
2011-12-29 11:00:00	SPY	ETF	125.8162	125.88	125.51	125.64	8018985.0
2011-12-29 11:30:00	SPY	ETF	125.63	125.96	125.63	125.95	7272336.0
2011-12-29 12:00:00	SPY	ETF	125.9505	125.97	125.76	125.8001	3634165.0
2011-12-29 12:30:00	SPY	ETF	125.8	125.85	125.65	125.84	2998109.0
2011-12-29 13:00:00	SPY	ETF	125.84	125.95	125.72	125.8	4487549.0
2011-12-29 13:30:00	SPY	ETF	125.81	125.99	125.78	125.88	5115039.0
2011-12-29 14:00:00	SPY	ETF	125.88	125.95	125.85	125.89	6191318.0
2011-12-29 14:30:00	SPY	ETF	125.89	125.92	125.82	125.86	2569387.0
2011-12-29 15:00:00	SPY	ETF	125.86	126.1	125.86	126.01	6976892.0
2011-12-29 15:30:00	SPY	ETF	126.005	126.25	125.99	126.16	19376124.0
2011-12-29 16:00:00	SPY	ETF	126.17	126.2	124.8567	126.09	15230178.0
2011-12-29 16:30:00	SPY	ETF	126.1	126.12	126.0	126.08	1674917.0
2011-12-29 17:00:00	SPY	ETF	126.09	126.15	126.03	126.03	1180622.0
2011-12-29 17:30:00	SPY	ETF	126.05	126.193	126.05	126.1	837377.0
2011-12-29 18:00:00	SPY	ETF	126.08	126.13	126.08	126.1	386789.0
2011-12-29 18:30:00	SPY	ETF	126.07	126.17	126.05	126.1	9460.0
2011-12-29 19:00:00	SPY	ETF	126.1	126.16	126.07	126.09	19050.0
2011-12-29 19:30:00	SPY	ETF	126.09	126.1	126.03	126.08	59475.0
2011-12-29 04:30:00	QQQ	ETF	55.58	55.58	55.58	55.58	100.0
2011-12-29 06:00:00	QQQ	ETF	55.63	55.63	55.63	55.63	1700.0
2011-12-29 06:30:00	QQQ	ETF	55.64	55.67	55.6	55.6	2100.0
2011-12-29 07:00:00	QQQ	ETF	55.61	55.65	55.58	55.65	9700.0
2011-12-29 07:30:00	QQQ	ETF	55.66	55.66	55.65	55.66	4400.0
2011-12-29 08:00:00	QQQ	ETF	55.68	55.75	55.6	55.63	101969.0
2011-12-29 08:30:00	QQQ	ETF	55.62	55.7	55.59	55.69	54718.0
2011-12-29 09:00:00	QQQ	ETF	55.69	55.69	55.63	55.69	33372.0
2011-12-29 09:30:00	QQQ	ETF	55.68	55.75	55.51	55.56	2948951.0
2011-12-29 10:00:00	QQQ	ETF	55.56	55.73	55.5	55.69	3043033.0
2011-12-29 10:30:00	QQQ	ETF	55.691	55.8	55.67	55.75	1943291.0
2011-12-29 11:00:00	QQQ	ETF	55.76	55.795	55.67	55.74	2169505.0
2011-12-29 11:30:00	QQQ	ETF	55.74	55.91	55.73	55.905	1881356.0
2011-12-29 12:00:00	QQQ	ETF	55.91	55.92	55.81	55.855	1491376.0
2011-12-29 12:30:00	QQQ	ETF	55.85	55.9	55.81	55.9	766568.0
2011-12-29 13:00:00	QQQ	ETF	55.9	55.98	55.86	55.89	1632874.0
2011-12-29 13:30:00	QQQ	ETF	55.89	55.97	55.88	55.91	966325.0
2011-12-29 14:00:00	QQQ	ETF	55.92	55.96	55.9	55.91	630610.0

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

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