PREVIEW / etf_30min / 2012-04-30

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-30.parquet
  size:    274 KB
  rows:    9,430

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-04-30 04:00:00	SPY	ETF	140.38	140.38	140.36	140.36	1600.0
2012-04-30 04:30:00	SPY	ETF	140.26	140.26	140.26	140.26	200.0
2012-04-30 05:00:00	SPY	ETF	140.2	140.2	140.2	140.2	500.0
2012-04-30 05:30:00	SPY	ETF	140.21	140.28	140.21	140.23	700.0
2012-04-30 06:00:00	SPY	ETF	140.14	140.18	140.13	140.18	700.0
2012-04-30 06:30:00	SPY	ETF	140.2	140.26	140.18	140.25	2700.0
2012-04-30 07:00:00	SPY	ETF	140.23	140.28	140.1	140.1	105281.0
2012-04-30 07:30:00	SPY	ETF	140.15	140.21	139.96	139.98	857673.0
2012-04-30 08:00:00	SPY	ETF	139.99	140.05	139.89	139.99	547011.0
2012-04-30 08:30:00	SPY	ETF	139.98	140.15	139.94	140.1	1474072.0
2012-04-30 09:00:00	SPY	ETF	140.12	140.16	140.01	140.09	2826373.0
2012-04-30 09:30:00	SPY	ETF	140.11	140.21	139.65	139.73	19586732.0
2012-04-30 10:00:00	SPY	ETF	139.73	140.06	139.64	139.87	10022765.0
2012-04-30 10:30:00	SPY	ETF	139.87	139.87	139.61	139.7191	9973671.0
2012-04-30 11:00:00	SPY	ETF	139.71	139.85	139.67	139.8	5808825.0
2012-04-30 11:30:00	SPY	ETF	139.81	139.85	139.64	139.82	4084104.0
2012-04-30 12:00:00	SPY	ETF	139.83	139.84	139.69	139.77	3230511.0
2012-04-30 12:30:00	SPY	ETF	139.77	139.87	139.72	139.77	3451036.0
2012-04-30 13:00:00	SPY	ETF	139.78	139.85	139.73	139.76	2364955.0
2012-04-30 13:30:00	SPY	ETF	139.76	139.79	139.64	139.75	3325637.0
2012-04-30 14:00:00	SPY	ETF	139.75	139.79	139.6	139.62	4748481.0
2012-04-30 14:30:00	SPY	ETF	139.619	139.68	139.49	139.65	4766940.0
2012-04-30 15:00:00	SPY	ETF	139.65	139.73	139.62	139.67	5093162.0
2012-04-30 15:30:00	SPY	ETF	139.68	139.92	139.67	139.82	15699679.0
2012-04-30 16:00:00	SPY	ETF	139.8	139.96	139.71	139.93	3729797.0
2012-04-30 16:30:00	SPY	ETF	139.93	140.06	139.876	140.06	3808937.0
2012-04-30 17:00:00	SPY	ETF	140.05	140.05	139.96	140.05	176330.0
2012-04-30 17:30:00	SPY	ETF	140.03	140.04	140.0	140.04	31947.0
2012-04-30 18:00:00	SPY	ETF	140.02	140.06	140.01	140.04	16821.0
2012-04-30 18:30:00	SPY	ETF	140.03	140.06	140.03	140.03	23260.0
2012-04-30 19:00:00	SPY	ETF	140.04	140.04	140.03	140.03	1857.0
2012-04-30 19:30:00	SPY	ETF	140.02	140.07	140.01	140.07	43975.0
2012-04-30 05:00:00	QQQ	ETF	67.24	67.24	67.17	67.17	200.0
2012-04-30 06:30:00	QQQ	ETF	67.15	67.2	67.15	67.2	12200.0
2012-04-30 07:00:00	QQQ	ETF	67.2	67.2	67.1	67.1	9150.0
2012-04-30 07:30:00	QQQ	ETF	67.12	67.12	66.96	66.96	236187.0
2012-04-30 08:00:00	QQQ	ETF	66.97	67.07	66.94	66.98	1101142.0
2012-04-30 08:30:00	QQQ	ETF	66.99	67.07	66.97	67.06	211659.0
2012-04-30 09:00:00	QQQ	ETF	67.06	67.07	66.97	67.01	2288242.0
2012-04-30 09:30:00	QQQ	ETF	67.02	67.17	66.79	66.84	7917400.0
2012-04-30 10:00:00	QQQ	ETF	66.83	66.96	66.74	66.85	2963174.0
2012-04-30 10:30:00	QQQ	ETF	66.84	66.95	66.76	66.89	2591561.0
2012-04-30 11:00:00	QQQ	ETF	66.885	66.95	66.82	66.89	1871391.0
2012-04-30 11:30:00	QQQ	ETF	66.89	66.98	66.75	66.98	1848575.0
2012-04-30 12:00:00	QQQ	ETF	66.975	66.98	66.84	66.85	1205820.0
2012-04-30 12:30:00	QQQ	ETF	66.85	66.935	66.81	66.87	1177086.0
2012-04-30 13:00:00	QQQ	ETF	66.8687	66.91	66.82	66.85	1021067.0
2012-04-30 13:30:00	QQQ	ETF	66.85	66.91	66.8	66.91	1005492.0
2012-04-30 14:00:00	QQQ	ETF	66.91	66.92	66.78	66.8	1326629.0
2012-04-30 14:30:00	QQQ	ETF	66.8	66.81	66.71	66.76	1985102.0

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

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