PREVIEW / etf_30min / 2011-05-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-19.parquet
  size:    275 KB
  rows:    9,112

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-05-19 04:00:00	SPY	ETF	134.3	134.36	134.3	134.36	8420.0
2011-05-19 04:30:00	SPY	ETF	134.22	134.25	134.18	134.25	300.0
2011-05-19 05:00:00	SPY	ETF	134.36	134.52	134.36	134.52	4550.0
2011-05-19 05:30:00	SPY	ETF	134.46	134.94	134.46	134.89	5449.0
2011-05-19 06:00:00	SPY	ETF	134.84	134.86	134.73	134.78	4450.0
2011-05-19 06:30:00	SPY	ETF	134.78	134.95	134.74	134.83	46700.0
2011-05-19 07:00:00	SPY	ETF	134.78	134.84	134.74	134.79	80050.0
2011-05-19 07:30:00	SPY	ETF	134.77	134.77	134.65	134.69	363399.0
2011-05-19 08:00:00	SPY	ETF	134.69	134.77	134.65	134.75	504278.0
2011-05-19 08:30:00	SPY	ETF	134.75	134.95	134.75	134.93	1526158.0
2011-05-19 09:00:00	SPY	ETF	134.93	134.93	134.75	134.81	972893.0
2011-05-19 09:30:00	SPY	ETF	134.8	135.03	134.67	134.93	12717137.0
2011-05-19 10:00:00	SPY	ETF	134.92	134.94	134.28	134.522	19416977.0
2011-05-19 10:30:00	SPY	ETF	134.525	134.56	134.01	134.06	10413425.0
2011-05-19 11:00:00	SPY	ETF	134.06	134.19	133.94	134.159	8145991.0
2011-05-19 11:30:00	SPY	ETF	134.15	134.25	134.09	134.14	5771298.0
2011-05-19 12:00:00	SPY	ETF	134.14	134.68	134.11	134.62	7289945.0
2011-05-19 12:30:00	SPY	ETF	134.615	134.72	134.47	134.53	5166604.0
2011-05-19 13:00:00	SPY	ETF	134.53	134.81	134.49	134.66	4305794.0
2011-05-19 13:30:00	SPY	ETF	134.65	134.77	134.52	134.71	3718210.0
2011-05-19 14:00:00	SPY	ETF	134.71	134.82	134.33	134.38	7457012.0
2011-05-19 14:30:00	SPY	ETF	134.38	134.47	134.14	134.4	6558046.0
2011-05-19 15:00:00	SPY	ETF	134.395	134.63	134.37	134.59	5034542.0
2011-05-19 15:30:00	SPY	ETF	134.59	134.72	134.51	134.66	13772258.0
2011-05-19 16:00:00	SPY	ETF	134.67	134.8987	134.3224	134.67	4582004.0
2011-05-19 16:30:00	SPY	ETF	134.66	134.7	134.1796	134.68	315783.0
2011-05-19 17:00:00	SPY	ETF	134.67	134.69	134.65	134.67	26483.0
2011-05-19 17:30:00	SPY	ETF	134.65	134.66	134.63	134.66	12800.0
2011-05-19 18:00:00	SPY	ETF	134.68	134.68	134.65	134.66	29343.0
2011-05-19 18:30:00	SPY	ETF	134.65	134.67	134.6	134.6	25653.0
2011-05-19 19:00:00	SPY	ETF	134.6	134.65	134.56	134.65	14697.0
2011-05-19 19:30:00	SPY	ETF	134.64	134.66	134.62	134.66	14684.0
2011-05-19 04:30:00	QQQ	ETF	58.0	58.0	58.0	58.0	200.0
2011-05-19 05:30:00	QQQ	ETF	58.07	58.1	58.07	58.1	200.0
2011-05-19 06:00:00	QQQ	ETF	58.18	58.18	58.18	58.18	3200.0
2011-05-19 06:30:00	QQQ	ETF	58.16	58.19	58.15	58.19	1500.0
2011-05-19 07:00:00	QQQ	ETF	58.16	58.2	58.16	58.2	5864.0
2011-05-19 07:30:00	QQQ	ETF	58.18	58.18	58.13	58.15	4400.0
2011-05-19 08:00:00	QQQ	ETF	58.15	58.18	58.11	58.18	178735.0
2011-05-19 08:30:00	QQQ	ETF	58.19	58.29	58.17	58.26	919507.0
2011-05-19 09:00:00	QQQ	ETF	58.26	58.27	58.23	58.23	213324.0
2011-05-19 09:30:00	QQQ	ETF	58.23	58.3	58.081	58.23	3985370.0
2011-05-19 10:00:00	QQQ	ETF	58.22	58.22	57.98	58.13	5507435.0
2011-05-19 10:30:00	QQQ	ETF	58.14	58.1499	57.87	57.92	2675436.0
2011-05-19 11:00:00	QQQ	ETF	57.915	58.01	57.85	57.99	2343468.0
2011-05-19 11:30:00	QQQ	ETF	57.985	58.01	57.92	57.95	899669.0
2011-05-19 12:00:00	QQQ	ETF	57.96	58.24	57.96	58.2195	2537865.0
2011-05-19 12:30:00	QQQ	ETF	58.22	58.3	58.185	58.239	3550876.0
2011-05-19 13:00:00	QQQ	ETF	58.235	58.33	58.2	58.28	1301127.0
2011-05-19 13:30:00	QQQ	ETF	58.275	58.32	58.21	58.28	1233484.0

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

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