PREVIEW / etf_30min / 2011-05-11

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-11.parquet
  size:    288 KB
  rows:    9,527

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-11 04:00:00	SPY	ETF	135.99	135.99	135.99	135.99	100.0
2011-05-11 04:30:00	SPY	ETF	136.03	136.03	136.03	136.03	550.0
2011-05-11 05:00:00	SPY	ETF	135.97	136.25	135.96	136.25	16150.0
2011-05-11 05:30:00	SPY	ETF	136.24	136.28	136.24	136.24	7300.0
2011-05-11 06:00:00	SPY	ETF	136.2	136.22	136.2	136.22	1100.0
2011-05-11 06:30:00	SPY	ETF	136.12	136.17	136.0	136.01	12500.0
2011-05-11 07:00:00	SPY	ETF	136.09	136.12	136.0	136.12	17000.0
2011-05-11 07:30:00	SPY	ETF	136.12	136.17	135.87	135.87	192325.0
2011-05-11 08:00:00	SPY	ETF	135.89	136.12	135.68	135.77	1181564.0
2011-05-11 08:30:00	SPY	ETF	135.77	135.87	135.72	135.82	1525756.0
2011-05-11 09:00:00	SPY	ETF	135.82	135.92	135.62	135.67	961020.0
2011-05-11 09:30:00	SPY	ETF	135.67	135.69	135.31	135.425	15313399.0
2011-05-11 10:00:00	SPY	ETF	135.41	135.46	135.19	135.37	11010593.0
2011-05-11 10:30:00	SPY	ETF	135.37	135.37	135.08	135.26	12017294.0
2011-05-11 11:00:00	SPY	ETF	135.265	135.42	135.21	135.31	5736051.0
2011-05-11 11:30:00	SPY	ETF	135.31	135.38	134.83	134.93	8766218.0
2011-05-11 12:00:00	SPY	ETF	134.93	134.9325	133.98	134.26	22446874.0
2011-05-11 12:30:00	SPY	ETF	134.265	134.5	134.1	134.4	12020363.0
2011-05-11 13:00:00	SPY	ETF	134.41	134.4584	134.17	134.185	9268429.0
2011-05-11 13:30:00	SPY	ETF	134.18	134.3	133.82	134.17	17061377.0
2011-05-11 14:00:00	SPY	ETF	134.17	134.24	133.86	134.0	12419742.0
2011-05-11 14:30:00	SPY	ETF	134.0	134.339	133.99	134.151	12688917.0
2011-05-11 15:00:00	SPY	ETF	134.15	134.48	134.09	134.34	8648222.0
2011-05-11 15:30:00	SPY	ETF	134.345	134.56	134.04	134.45	23591769.0
2011-05-11 16:00:00	SPY	ETF	134.45	135.9384	134.26	134.45	8430359.0
2011-05-11 16:30:00	SPY	ETF	134.44	134.45	134.06	134.08	5685955.0
2011-05-11 17:00:00	SPY	ETF	134.08	134.11	133.99	134.02	1523516.0
2011-05-11 17:30:00	SPY	ETF	134.02	134.02	133.95	134.0	51896.0
2011-05-11 18:00:00	SPY	ETF	134.0	134.45	134.0	134.03	156549.0
2011-05-11 18:30:00	SPY	ETF	134.03	134.16	134.03	134.16	29241.0
2011-05-11 19:00:00	SPY	ETF	134.14	134.14	134.11	134.12	6200.0
2011-05-11 19:30:00	SPY	ETF	134.11	134.19	134.09	134.12	58156.0
2011-05-11 06:30:00	QQQ	ETF	59.29	59.29	59.25	59.25	4200.0
2011-05-11 07:00:00	QQQ	ETF	59.21	59.26	59.21	59.26	1300.0
2011-05-11 07:30:00	QQQ	ETF	59.27	59.27	59.17	59.17	11100.0
2011-05-11 08:00:00	QQQ	ETF	59.19	59.2	59.11	59.13	90929.0
2011-05-11 08:30:00	QQQ	ETF	59.12	59.18	59.12	59.14	1174504.0
2011-05-11 09:00:00	QQQ	ETF	59.14	59.21	59.08	59.11	619795.0
2011-05-11 09:30:00	QQQ	ETF	59.11	59.31	59.04	59.21	5082764.0
2011-05-11 10:00:00	QQQ	ETF	59.2	59.28	59.12	59.2462	3134541.0
2011-05-11 10:30:00	QQQ	ETF	59.24	59.24	59.07	59.16	2607144.0
2011-05-11 11:00:00	QQQ	ETF	59.155	59.2	59.11	59.14	1556044.0
2011-05-11 11:30:00	QQQ	ETF	59.14	59.175	58.88	58.9099	2490274.0
2011-05-11 12:00:00	QQQ	ETF	58.9	58.91	58.49	58.5949	6154763.0
2011-05-11 12:30:00	QQQ	ETF	58.59	58.72	58.55	58.68	3114360.0
2011-05-11 13:00:00	QQQ	ETF	58.69	58.71	58.55	58.55	2696384.0
2011-05-11 13:30:00	QQQ	ETF	58.5599	58.6	58.36	58.49	5125581.0
2011-05-11 14:00:00	QQQ	ETF	58.49	58.559	58.43	58.47	2427866.0
2011-05-11 14:30:00	QQQ	ETF	58.48	58.66	58.47	58.59	3883748.0
2011-05-11 15:00:00	QQQ	ETF	58.58	58.75	58.55	58.6885	2197770.0

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

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