PREVIEW / etf_30min / 2012-10-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-02.parquet
  size:    282 KB
  rows:    9,495

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-02 04:00:00	SPY	ETF	144.7	144.74	144.69	144.74	98285.0
2012-10-02 04:30:00	SPY	ETF	144.69	144.9	144.69	144.9	31215.0
2012-10-02 05:00:00	SPY	ETF	144.9	145.03	144.9	144.97	22500.0
2012-10-02 05:30:00	SPY	ETF	144.96	144.96	144.9	144.9	1600.0
2012-10-02 06:00:00	SPY	ETF	144.95	145.16	144.95	145.08	23950.0
2012-10-02 06:30:00	SPY	ETF	145.1	145.14	145.08	145.08	24150.0
2012-10-02 07:00:00	SPY	ETF	145.02	145.08	144.91	144.96	86536.0
2012-10-02 07:30:00	SPY	ETF	144.98	145.05	144.95	145.03	85379.0
2012-10-02 08:00:00	SPY	ETF	145.0	145.1	144.98	145.0	252272.0
2012-10-02 08:30:00	SPY	ETF	144.98	144.99	144.84	144.92	280783.0
2012-10-02 09:00:00	SPY	ETF	144.89	144.94	144.8	144.92	456245.0
2012-10-02 09:30:00	SPY	ETF	144.92	145.15	144.69	144.73	12874601.0
2012-10-02 10:00:00	SPY	ETF	144.73	144.75	144.37	144.75	9377753.0
2012-10-02 10:30:00	SPY	ETF	144.74	144.935	144.32	144.41	7920368.0
2012-10-02 11:00:00	SPY	ETF	144.4	144.55	144.28	144.39	6635810.0
2012-10-02 11:30:00	SPY	ETF	144.39	144.59	143.89	144.06	15851921.0
2012-10-02 12:00:00	SPY	ETF	144.06	144.37	143.98	144.26	6483308.0
2012-10-02 12:30:00	SPY	ETF	144.26	144.33	144.1	144.2	3555347.0
2012-10-02 13:00:00	SPY	ETF	144.2	144.28	144.12	144.175	2043646.0
2012-10-02 13:30:00	SPY	ETF	144.18	144.44	143.96	144.12	7263302.0
2012-10-02 14:00:00	SPY	ETF	144.12	144.22	143.86	143.99	5130431.0
2012-10-02 14:30:00	SPY	ETF	143.98	144.02	143.83	143.8998	5381800.0
2012-10-02 15:00:00	SPY	ETF	143.9	144.24	143.83	144.2201	6859087.0
2012-10-02 15:30:00	SPY	ETF	144.23	144.55	144.19	144.48	13519491.0
2012-10-02 16:00:00	SPY	ETF	144.48	144.74	144.1884	144.58	4202036.0
2012-10-02 16:30:00	SPY	ETF	144.59	144.6359	144.53	144.58	4640850.0
2012-10-02 17:00:00	SPY	ETF	144.58	144.66	144.58	144.63	24380.0
2012-10-02 17:30:00	SPY	ETF	144.61	144.66	144.61	144.66	5211.0
2012-10-02 18:00:00	SPY	ETF	144.67	144.67	144.57	144.64	23971.0
2012-10-02 18:30:00	SPY	ETF	144.64	144.64	144.55	144.55	30700.0
2012-10-02 19:00:00	SPY	ETF	144.55	144.56	144.53	144.56	7795.0
2012-10-02 19:30:00	SPY	ETF	144.53	144.56	144.51	144.56	13450.0
2012-10-02 06:00:00	QQQ	ETF	68.8	68.82	68.8	68.82	6000.0
2012-10-02 06:30:00	QQQ	ETF	68.87	68.87	68.87	68.87	400.0
2012-10-02 07:00:00	QQQ	ETF	68.83	68.83	68.75	68.77	14981.0
2012-10-02 07:30:00	QQQ	ETF	68.78	68.83	68.78	68.83	9500.0
2012-10-02 08:00:00	QQQ	ETF	68.81	68.88	68.8	68.83	35707.0
2012-10-02 08:30:00	QQQ	ETF	68.81	68.81	68.76	68.79	26310.0
2012-10-02 09:00:00	QQQ	ETF	68.78	68.8	68.75	68.78	47819.0
2012-10-02 09:30:00	QQQ	ETF	68.79	68.98	68.6399	68.78	4837289.0
2012-10-02 10:00:00	QQQ	ETF	68.78	68.88	68.51	68.88	3341625.0
2012-10-02 10:30:00	QQQ	ETF	68.89	68.96	68.64	68.69	2443227.0
2012-10-02 11:00:00	QQQ	ETF	68.68	68.73	68.57	68.6101	1692414.0
2012-10-02 11:30:00	QQQ	ETF	68.62	68.7399	68.36	68.41	3128427.0
2012-10-02 12:00:00	QQQ	ETF	68.4	68.56	68.36	68.47	1323399.0
2012-10-02 12:30:00	QQQ	ETF	68.47	68.51	68.38	68.4	970767.0
2012-10-02 13:00:00	QQQ	ETF	68.4083	68.48	68.33	68.36	1088713.0
2012-10-02 13:30:00	QQQ	ETF	68.36	68.51	68.29	68.35	2716395.0
2012-10-02 14:00:00	QQQ	ETF	68.34	68.4	68.2	68.2416	1521157.0
2012-10-02 14:30:00	QQQ	ETF	68.24	68.26	68.13	68.17	1294398.0

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

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