PREVIEW / etf_30min / 2011-12-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-07.parquet
  size:    281 KB
  rows:    9,395

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-07 04:00:00	SPY	ETF	127.35	127.35	127.06	127.13	1633.0
2011-12-07 04:30:00	SPY	ETF	127.06	127.06	126.86	126.86	1700.0
2011-12-07 05:00:00	SPY	ETF	126.87	127.0	126.8	127.0	3700.0
2011-12-07 05:30:00	SPY	ETF	127.02	127.11	126.7	126.78	45760.0
2011-12-07 06:00:00	SPY	ETF	126.7	126.75	126.53	126.6	64765.0
2011-12-07 06:30:00	SPY	ETF	126.58	126.83	126.55	126.7	138735.0
2011-12-07 07:00:00	SPY	ETF	126.73	126.76	126.38	126.57	676830.0
2011-12-07 07:30:00	SPY	ETF	126.57	126.61	126.17	126.25	1069519.0
2011-12-07 08:00:00	SPY	ETF	126.22	126.68	125.5	125.64	3978098.0
2011-12-07 08:30:00	SPY	ETF	125.67	126.22	125.53	125.86	3744019.0
2011-12-07 09:00:00	SPY	ETF	125.84	126.11	125.66	125.84	1734614.0
2011-12-07 09:30:00	SPY	ETF	125.84	125.86	125.13	125.51	21419810.0
2011-12-07 10:00:00	SPY	ETF	125.51	125.55	124.98	125.15	16978630.0
2011-12-07 10:30:00	SPY	ETF	125.14	125.51	124.97	125.51	14417243.0
2011-12-07 11:00:00	SPY	ETF	125.51	125.86	125.44	125.82	13270862.0
2011-12-07 11:30:00	SPY	ETF	125.83	125.99	125.81	125.95	10485338.0
2011-12-07 12:00:00	SPY	ETF	125.94	126.32	125.79	126.29	13224714.0
2011-12-07 12:30:00	SPY	ETF	126.28	126.43	126.0	126.37	7304714.0
2011-12-07 13:00:00	SPY	ETF	126.36	126.4	126.12	126.3441	8507532.0
2011-12-07 13:30:00	SPY	ETF	126.35	126.37	125.99	126.115	11802286.0
2011-12-07 14:00:00	SPY	ETF	126.12	126.21	125.86	126.1	10037041.0
2011-12-07 14:30:00	SPY	ETF	126.1	126.17	125.68	125.81	12588360.0
2011-12-07 15:00:00	SPY	ETF	125.82	126.46	125.75	126.405	13114678.0
2011-12-07 15:30:00	SPY	ETF	126.41	127.26	126.3	126.65	38470809.0
2011-12-07 16:00:00	SPY	ETF	126.65	127.02	125.95	126.95	20398171.0
2011-12-07 16:30:00	SPY	ETF	126.95	127.04	125.25	126.88	5172757.0
2011-12-07 17:00:00	SPY	ETF	126.88	127.18	126.88	127.13	210431.0
2011-12-07 17:30:00	SPY	ETF	127.14	127.21	127.11	127.16	121829.0
2011-12-07 18:00:00	SPY	ETF	127.16	127.19	126.75	127.15	395703.0
2011-12-07 18:30:00	SPY	ETF	127.13	127.15	126.89	126.89	135693.0
2011-12-07 19:00:00	SPY	ETF	126.89	127.08	126.83	127.01	199907.0
2011-12-07 19:30:00	SPY	ETF	127.0	127.14	126.92	127.11	248382.0
2011-12-07 04:00:00	QQQ	ETF	57.57	57.58	57.55	57.55	2800.0
2011-12-07 04:30:00	QQQ	ETF	57.49	57.49	57.49	57.49	600.0
2011-12-07 05:00:00	QQQ	ETF	57.5	57.5	57.5	57.5	1800.0
2011-12-07 06:00:00	QQQ	ETF	57.37	57.37	57.29	57.29	2200.0
2011-12-07 06:30:00	QQQ	ETF	57.3	57.35	57.3	57.34	4400.0
2011-12-07 07:00:00	QQQ	ETF	57.29	57.29	57.23	57.27	5600.0
2011-12-07 07:30:00	QQQ	ETF	57.27	57.28	57.1	57.11	7978.0
2011-12-07 08:00:00	QQQ	ETF	57.11	57.13	56.83	56.86	904816.0
2011-12-07 08:30:00	QQQ	ETF	56.87	57.08	56.83	56.94	233281.0
2011-12-07 09:00:00	QQQ	ETF	56.91	57.0	56.84	56.91	1142614.0
2011-12-07 09:30:00	QQQ	ETF	56.91	56.93	56.365	56.53	6945622.0
2011-12-07 10:00:00	QQQ	ETF	56.53	56.59	56.35	56.4136	1825862.0
2011-12-07 10:30:00	QQQ	ETF	56.41	56.64	56.36	56.63	3131065.0
2011-12-07 11:00:00	QQQ	ETF	56.63	56.81	56.61	56.8	3382806.0
2011-12-07 11:30:00	QQQ	ETF	56.8	56.95	56.8	56.92	2989190.0
2011-12-07 12:00:00	QQQ	ETF	56.92	57.03	56.81	57.01	1715100.0
2011-12-07 12:30:00	QQQ	ETF	57.0	57.1	56.97	57.06	2537805.0
2011-12-07 13:00:00	QQQ	ETF	57.07	57.09	56.93	57.02	1530081.0

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

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