PREVIEW / etf_30min / 2013-11-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-15.parquet
  size:    325 KB
  rows:    11,100

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-11-15 04:00:00	SPY	ETF	179.4	179.5	179.15	179.5	6685.0
2013-11-15 04:30:00	SPY	ETF	179.49	179.5	179.44	179.48	26428.0
2013-11-15 05:00:00	SPY	ETF	179.49	179.52	179.49	179.52	4309.0
2013-11-15 05:30:00	SPY	ETF	179.52	179.69	179.52	179.64	11901.0
2013-11-15 06:00:00	SPY	ETF	179.62	179.73	179.61	179.64	53100.0
2013-11-15 06:30:00	SPY	ETF	179.64	179.78	179.64	179.69	68470.0
2013-11-15 07:00:00	SPY	ETF	179.7	179.78	179.61	179.64	138255.0
2013-11-15 07:30:00	SPY	ETF	179.62	179.74	179.61	179.71	125889.0
2013-11-15 08:00:00	SPY	ETF	179.69	179.73	179.62	179.64	507295.0
2013-11-15 08:30:00	SPY	ETF	179.67	179.68	179.58	179.64	284595.0
2013-11-15 09:00:00	SPY	ETF	179.65	179.7	179.45	179.57	1490224.0
2013-11-15 09:30:00	SPY	ETF	179.56	179.6	179.33	179.5401	15884768.0
2013-11-15 10:00:00	SPY	ETF	179.54	179.64	179.38	179.56	9580589.0
2013-11-15 10:30:00	SPY	ETF	179.555	179.67	179.44	179.6	5507902.0
2013-11-15 11:00:00	SPY	ETF	179.59	179.72	179.58	179.64	3317627.0
2013-11-15 11:30:00	SPY	ETF	179.64	179.68	179.33	179.41	6465791.0
2013-11-15 12:00:00	SPY	ETF	179.4101	179.54	179.37	179.47	3325885.0
2013-11-15 12:30:00	SPY	ETF	179.47	179.52	179.36	179.38	2470401.0
2013-11-15 13:00:00	SPY	ETF	179.389	179.63	179.38	179.6	2310808.0
2013-11-15 13:30:00	SPY	ETF	179.59	179.69	179.55	179.5953	2688174.0
2013-11-15 14:00:00	SPY	ETF	179.59	179.77	179.59	179.7	2877158.0
2013-11-15 14:30:00	SPY	ETF	179.7	179.79	179.69	179.735	2519721.0
2013-11-15 15:00:00	SPY	ETF	179.74	180.0	179.7	179.97	7380229.0
2013-11-15 15:30:00	SPY	ETF	179.97	180.07	179.85	180.06	15506453.0
2013-11-15 16:00:00	SPY	ETF	180.06	180.12	179.3079	179.9	10261108.0
2013-11-15 16:30:00	SPY	ETF	179.9	180.05	179.89	179.91	2411637.0
2013-11-15 17:00:00	SPY	ETF	179.9	179.94	179.9	179.92	194296.0
2013-11-15 17:30:00	SPY	ETF	179.94	179.94	179.89	179.92	11780.0
2013-11-15 18:00:00	SPY	ETF	179.92	179.92	179.82	179.89	36639.0
2013-11-15 18:30:00	SPY	ETF	179.89	179.92	179.89	179.9	4092.0
2013-11-15 19:00:00	SPY	ETF	179.87	179.9	179.87	179.87	1800.0
2013-11-15 19:30:00	SPY	ETF	179.9	179.9	179.87	179.9	19050.0
2013-11-15 04:00:00	QQQ	ETF	83.86	83.9	83.71	83.89	11600.0
2013-11-15 04:30:00	QQQ	ETF	83.88	83.88	83.87	83.87	1000.0
2013-11-15 05:00:00	QQQ	ETF	83.89	83.89	83.89	83.89	900.0
2013-11-15 05:30:00	QQQ	ETF	83.91	83.93	83.91	83.93	3500.0
2013-11-15 06:00:00	QQQ	ETF	83.91	83.95	83.91	83.93	5740.0
2013-11-15 06:30:00	QQQ	ETF	83.95	83.97	83.93	83.93	4970.0
2013-11-15 07:00:00	QQQ	ETF	83.95	83.95	83.84	83.84	12150.0
2013-11-15 07:30:00	QQQ	ETF	83.84	83.87	83.83	83.87	14528.0
2013-11-15 08:00:00	QQQ	ETF	83.85	83.87	83.72	83.83	37057.0
2013-11-15 08:30:00	QQQ	ETF	83.84	83.85	83.82	83.84	28923.0
2013-11-15 09:00:00	QQQ	ETF	83.84	83.85	83.75	83.83	125886.0
2013-11-15 09:30:00	QQQ	ETF	83.83	83.86	83.61	83.75	3302991.0
2013-11-15 10:00:00	QQQ	ETF	83.75	83.85	83.69	83.78	2620971.0
2013-11-15 10:30:00	QQQ	ETF	83.78	83.83	83.72	83.75	1679167.0
2013-11-15 11:00:00	QQQ	ETF	83.75	83.86	83.75	83.7812	804569.0
2013-11-15 11:30:00	QQQ	ETF	83.78	83.7975	83.64	83.68	1147068.0
2013-11-15 12:00:00	QQQ	ETF	83.69	83.77	83.65	83.72	626549.0
2013-11-15 12:30:00	QQQ	ETF	83.71	83.75	83.67	83.6865	467143.0

> showing 50 of 11,100 rows — these rows as CSV

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