PREVIEW / etf_30min / 2012-10-01

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-01.parquet
  size:    292 KB
  rows:    9,804

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-01 04:00:00	SPY	ETF	144.3	144.35	144.3	144.35	6000.0
2012-10-01 04:30:00	SPY	ETF	144.37	144.66	144.37	144.66	23050.0
2012-10-01 05:00:00	SPY	ETF	144.7	144.7	144.7	144.7	500.0
2012-10-01 05:30:00	SPY	ETF	144.64	144.64	144.61	144.61	400.0
2012-10-01 06:00:00	SPY	ETF	144.51	144.59	144.5	144.55	3100.0
2012-10-01 06:30:00	SPY	ETF	144.61	144.61	144.59	144.6	1950.0
2012-10-01 07:00:00	SPY	ETF	144.6	144.61	144.46	144.47	48540.0
2012-10-01 07:30:00	SPY	ETF	144.5	144.56	144.43	144.54	117420.0
2012-10-01 08:00:00	SPY	ETF	144.51	144.74	143.93	144.5	307078.0
2012-10-01 08:30:00	SPY	ETF	144.55	144.73	143.97	144.67	398839.0
2012-10-01 09:00:00	SPY	ETF	143.97	144.68	143.93	144.53	661585.0
2012-10-01 09:30:00	SPY	ETF	144.52	144.91	144.43	144.7	12930033.0
2012-10-01 10:00:00	SPY	ETF	144.71	145.69	144.71	145.43	18233566.0
2012-10-01 10:30:00	SPY	ETF	145.43	145.46	145.22	145.34	6536510.0
2012-10-01 11:00:00	SPY	ETF	145.33	145.54	145.32	145.4	7428449.0
2012-10-01 11:30:00	SPY	ETF	145.4	145.42	145.07	145.15	7306627.0
2012-10-01 12:00:00	SPY	ETF	145.15	145.26	145.13	145.25	4648688.0
2012-10-01 12:30:00	SPY	ETF	145.25	145.33	144.71	144.89	9749554.0
2012-10-01 13:00:00	SPY	ETF	144.88	144.9	144.41	144.69	9982690.0
2012-10-01 13:30:00	SPY	ETF	144.69	144.87	144.39	144.84	7234363.0
2012-10-01 14:00:00	SPY	ETF	144.84	144.96	144.64	144.74	6569450.0
2012-10-01 14:30:00	SPY	ETF	144.74	144.925	144.68	144.8827	4994028.0
2012-10-01 15:00:00	SPY	ETF	144.88	144.89	144.02	144.25	11781533.0
2012-10-01 15:30:00	SPY	ETF	144.245	144.46	144.12	144.33	13359092.0
2012-10-01 16:00:00	SPY	ETF	144.33	146.0	144.0082	144.26	4426881.0
2012-10-01 16:30:00	SPY	ETF	144.26	144.5828	144.0082	144.26	2003857.0
2012-10-01 17:00:00	SPY	ETF	144.26	144.35	144.25	144.26	1678295.0
2012-10-01 17:30:00	SPY	ETF	144.26	144.27	144.13	144.25	3065891.0
2012-10-01 18:00:00	SPY	ETF	144.27	144.35	144.26	144.35	25052.0
2012-10-01 18:30:00	SPY	ETF	144.34	144.34	144.3	144.31	3340.0
2012-10-01 19:00:00	SPY	ETF	144.31	144.34	144.25	144.25	5340.0
2012-10-01 19:30:00	SPY	ETF	144.28	144.3	144.22	144.3	27707.0
2012-10-01 04:00:00	QQQ	ETF	68.82	68.82	68.82	68.82	100.0
2012-10-01 05:00:00	QQQ	ETF	69.0	69.0	69.0	69.0	180.0
2012-10-01 05:30:00	QQQ	ETF	68.95	68.96	68.95	68.96	200.0
2012-10-01 06:00:00	QQQ	ETF	68.93	68.95	68.93	68.95	1000.0
2012-10-01 06:30:00	QQQ	ETF	68.93	68.93	68.93	68.93	300.0
2012-10-01 07:00:00	QQQ	ETF	68.97	68.97	68.9	68.93	4909.0
2012-10-01 07:30:00	QQQ	ETF	68.96	68.97	68.91	68.94	58874.0
2012-10-01 08:00:00	QQQ	ETF	68.93	68.95	68.91	68.92	21825.0
2012-10-01 08:30:00	QQQ	ETF	68.94	69.03	68.94	69.0	62775.0
2012-10-01 09:00:00	QQQ	ETF	68.98	69.0	68.89	68.91	110635.0
2012-10-01 09:30:00	QQQ	ETF	68.9	69.06	68.8	68.84	2986375.0
2012-10-01 10:00:00	QQQ	ETF	68.84	69.33	68.84	69.14	4642164.0
2012-10-01 10:30:00	QQQ	ETF	69.15	69.16	68.96	69.04	1394226.0
2012-10-01 11:00:00	QQQ	ETF	69.035	69.175	69.03	69.08	2847960.0
2012-10-01 11:30:00	QQQ	ETF	69.08	69.1	68.91	68.94	1046776.0
2012-10-01 12:00:00	QQQ	ETF	68.94	68.98	68.82	68.9001	1341277.0
2012-10-01 12:30:00	QQQ	ETF	68.91	68.94	68.6	68.7	2181898.0
2012-10-01 13:00:00	QQQ	ETF	68.7	68.73	68.46	68.6208	2858837.0

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

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