PREVIEW / etf_30min / 2011-04-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-08.parquet
  size:    280 KB
  rows:    9,303

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-04-08 04:00:00	SPY	ETF	133.35	133.74	133.35	133.6	17000.0
2011-04-08 04:30:00	SPY	ETF	133.6	133.64	133.58	133.64	3300.0
2011-04-08 05:00:00	SPY	ETF	133.75	133.81	133.75	133.8	4050.0
2011-04-08 05:30:00	SPY	ETF	133.77	133.77	133.73	133.75	400.0
2011-04-08 06:00:00	SPY	ETF	133.8	133.83	133.76	133.76	9000.0
2011-04-08 06:30:00	SPY	ETF	133.77	133.83	133.77	133.82	41700.0
2011-04-08 07:00:00	SPY	ETF	133.84	133.86	133.79	133.84	299830.0
2011-04-08 07:30:00	SPY	ETF	133.84	134.0	133.81	133.93	349340.0
2011-04-08 08:00:00	SPY	ETF	133.93	133.97	133.82	133.93	591501.0
2011-04-08 08:30:00	SPY	ETF	133.94	133.95	133.82	133.82	414310.0
2011-04-08 09:00:00	SPY	ETF	133.83	133.93	133.83	133.9	742826.0
2011-04-08 09:30:00	SPY	ETF	133.91	133.99	133.5	133.6433	15355974.0
2011-04-08 10:00:00	SPY	ETF	133.65	133.73	133.29	133.36	10541813.0
2011-04-08 10:30:00	SPY	ETF	133.36	133.53	133.28	133.29	8522320.0
2011-04-08 11:00:00	SPY	ETF	133.29	133.39	133.17	133.225	9965188.0
2011-04-08 11:30:00	SPY	ETF	133.23	133.49	133.19	133.37	5610484.0
2011-04-08 12:00:00	SPY	ETF	133.36	133.43	133.26	133.31	2452412.0
2011-04-08 12:30:00	SPY	ETF	133.32	133.41	133.1	133.18	4737299.0
2011-04-08 13:00:00	SPY	ETF	133.1816	133.27	133.14	133.22	4095562.0
2011-04-08 13:30:00	SPY	ETF	133.22	133.25	133.1	133.22	4494240.0
2011-04-08 14:00:00	SPY	ETF	133.22	133.24	132.94	133.02	6467327.0
2011-04-08 14:30:00	SPY	ETF	133.019	133.04	132.35	132.39	18533918.0
2011-04-08 15:00:00	SPY	ETF	132.39	132.64	132.31	132.6	16074999.0
2011-04-08 15:30:00	SPY	ETF	132.6	132.96	132.55	132.85	19928578.0
2011-04-08 16:00:00	SPY	ETF	132.86	133.63	132.5562	132.85	15070856.0
2011-04-08 16:30:00	SPY	ETF	132.84	132.89	132.7	132.75	2494057.0
2011-04-08 17:00:00	SPY	ETF	132.75	132.84	132.75	132.83	392540.0
2011-04-08 17:30:00	SPY	ETF	132.83	132.83	132.78	132.79	70600.0
2011-04-08 18:00:00	SPY	ETF	132.79	132.86	132.75	132.78	95627.0
2011-04-08 18:30:00	SPY	ETF	132.76	132.76	132.68	132.69	27016.0
2011-04-08 19:00:00	SPY	ETF	132.73	132.75	132.68	132.7	19442.0
2011-04-08 19:30:00	SPY	ETF	132.71	132.83	132.68	132.7	52687.0
2011-04-08 04:00:00	QQQ	ETF	57.38	57.38	57.38	57.38	780.0
2011-04-08 05:00:00	QQQ	ETF	57.41	57.41	57.41	57.41	200.0
2011-04-08 05:30:00	QQQ	ETF	57.4	57.4	57.4	57.4	200.0
2011-04-08 07:00:00	QQQ	ETF	57.41	57.42	57.36	57.42	20482.0
2011-04-08 07:30:00	QQQ	ETF	57.38	57.48	57.38	57.45	134283.0
2011-04-08 08:00:00	QQQ	ETF	57.45	57.47	57.37	57.47	619463.0
2011-04-08 08:30:00	QQQ	ETF	57.46	57.46	57.41	57.41	36605.0
2011-04-08 09:00:00	QQQ	ETF	57.42	57.5	57.41	57.48	167238.0
2011-04-08 09:30:00	QQQ	ETF	57.48	57.57	57.21	57.31	4365466.0
2011-04-08 10:00:00	QQQ	ETF	57.31	57.37	57.08	57.15	3685049.0
2011-04-08 10:30:00	QQQ	ETF	57.16	57.26	57.13	57.15	2770445.0
2011-04-08 11:00:00	QQQ	ETF	57.1531	57.21	57.11	57.15	2605951.0
2011-04-08 11:30:00	QQQ	ETF	57.1475	57.3	57.13	57.24	1777800.0
2011-04-08 12:00:00	QQQ	ETF	57.24	57.27	57.2	57.23	446348.0
2011-04-08 12:30:00	QQQ	ETF	57.22	57.27	57.1	57.15	868074.0
2011-04-08 13:00:00	QQQ	ETF	57.14	57.22	57.125	57.1884	1700838.0
2011-04-08 13:30:00	QQQ	ETF	57.1899	57.2	57.12	57.17	1288444.0
2011-04-08 14:00:00	QQQ	ETF	57.17	57.18	57.02	57.06	1553986.0

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

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