PREVIEW / etf_30min / 2013-03-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-15.parquet
  size:    296 KB
  rows:    10,302

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
2013-03-15 04:00:00	SPY	ETF	156.41	156.41	155.97	156.04	28966.0
2013-03-15 04:30:00	SPY	ETF	156.0	156.01	155.89	155.98	10264.0
2013-03-15 05:00:00	SPY	ETF	155.98	155.98	155.85	155.85	5650.0
2013-03-15 05:30:00	SPY	ETF	155.88	155.88	155.82	155.88	1484.0
2013-03-15 06:00:00	SPY	ETF	155.85	155.88	155.81	155.88	22920.0
2013-03-15 06:30:00	SPY	ETF	155.91	155.95	155.85	155.85	23760.0
2013-03-15 07:00:00	SPY	ETF	155.88	155.92	155.85	155.9	35152.0
2013-03-15 07:30:00	SPY	ETF	155.89	156.02	155.88	156.01	304093.0
2013-03-15 08:00:00	SPY	ETF	155.88	156.11	155.88	156.03	439758.0
2013-03-15 08:30:00	SPY	ETF	156.06	156.15	155.95	156.09	494089.0
2013-03-15 09:00:00	SPY	ETF	156.09	156.12	155.77	155.85	2056267.0
2013-03-15 09:30:00	SPY	ETF	155.85	155.89	155.44	155.45	21359694.0
2013-03-15 10:00:00	SPY	ETF	155.44	155.68	155.31	155.59	12042149.0
2013-03-15 10:30:00	SPY	ETF	155.59	155.79	155.575	155.7	6178595.0
2013-03-15 11:00:00	SPY	ETF	155.71	155.94	155.69	155.88	6503469.0
2013-03-15 11:30:00	SPY	ETF	155.885	155.95	155.84	155.885	6613586.0
2013-03-15 12:00:00	SPY	ETF	155.885	155.96	155.83	155.91	3245779.0
2013-03-15 12:30:00	SPY	ETF	155.91	156.04	155.87	155.89	4806638.0
2013-03-15 13:00:00	SPY	ETF	155.89	155.91	155.82	155.8399	3582090.0
2013-03-15 13:30:00	SPY	ETF	155.839	155.88	155.8	155.805	2857558.0
2013-03-15 14:00:00	SPY	ETF	155.81	155.85	155.59	155.6	7277369.0
2013-03-15 14:30:00	SPY	ETF	155.605	155.66	155.47	155.59	7998821.0
2013-03-15 15:00:00	SPY	ETF	155.59	155.7	155.53	155.64	5165585.0
2013-03-15 15:30:00	SPY	ETF	155.65	155.84	155.59	155.84	16982600.0
2013-03-15 16:00:00	SPY	ETF	155.83	156.0272	155.35	155.75	6877535.0
2013-03-15 16:30:00	SPY	ETF	155.75	155.8308	155.7	155.76	4531683.0
2013-03-15 17:00:00	SPY	ETF	155.76	155.76	155.68	155.72	233323.0
2013-03-15 17:30:00	SPY	ETF	155.72	155.87	155.72	155.85	4631429.0
2013-03-15 18:00:00	SPY	ETF	155.83	155.87	155.79	155.82	76654.0
2013-03-15 18:30:00	SPY	ETF	155.82	155.83	155.81	155.82	6636.0
2013-03-15 19:00:00	SPY	ETF	155.79	155.82	155.79	155.79	3500.0
2013-03-15 19:30:00	SPY	ETF	155.79	155.83	155.77	155.77	7146.0
2013-03-15 04:00:00	QQQ	ETF	68.68	68.68	68.68	68.68	10000.0
2013-03-15 04:30:00	QQQ	ETF	68.69	68.69	68.69	68.69	300.0
2013-03-15 05:00:00	QQQ	ETF	68.7	68.7	68.7	68.7	198.0
2013-03-15 05:30:00	QQQ	ETF	68.65	68.65	68.65	68.65	100.0
2013-03-15 06:00:00	QQQ	ETF	68.65	68.67	68.65	68.67	14700.0
2013-03-15 06:30:00	QQQ	ETF	68.67	68.67	68.67	68.67	9600.0
2013-03-15 07:00:00	QQQ	ETF	68.7	68.73	68.67	68.72	5380.0
2013-03-15 07:30:00	QQQ	ETF	68.71	68.77	68.71	68.74	81000.0
2013-03-15 08:00:00	QQQ	ETF	68.76	68.81	68.74	68.78	40410.0
2013-03-15 08:30:00	QQQ	ETF	68.77	68.81	68.76	68.78	125682.0
2013-03-15 09:00:00	QQQ	ETF	68.78	68.81	68.67	68.74	332783.0
2013-03-15 09:30:00	QQQ	ETF	68.75	68.79	68.47	68.48	5284719.0
2013-03-15 10:00:00	QQQ	ETF	68.47	68.55	68.391	68.5	2755293.0
2013-03-15 10:30:00	QQQ	ETF	68.51	68.5699	68.47	68.501	993931.0
2013-03-15 11:00:00	QQQ	ETF	68.51	68.68	68.49	68.6399	1366252.0
2013-03-15 11:30:00	QQQ	ETF	68.64	68.67	68.6	68.615	997636.0
2013-03-15 12:00:00	QQQ	ETF	68.601	68.64	68.57	68.62	826667.0
2013-03-15 12:30:00	QQQ	ETF	68.62	68.7	68.605	68.625	1036972.0

> showing 50 of 10,302 rows — these rows as CSV

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