PREVIEW / etf_30min / 2014-06-23

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-23.parquet
  size:    329 KB
  rows:    11,444

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
2014-06-23 04:00:00	SPY	ETF	195.94	195.94	195.71	195.76	4783.0
2014-06-23 04:30:00	SPY	ETF	195.8	195.87	195.8	195.82	800.0
2014-06-23 05:00:00	SPY	ETF	195.86	195.86	195.84	195.84	575.0
2014-06-23 05:30:00	SPY	ETF	195.86	196.07	195.86	196.03	2400.0
2014-06-23 06:00:00	SPY	ETF	196.04	196.05	195.98	195.98	2301.0
2014-06-23 06:30:00	SPY	ETF	195.95	195.95	195.75	195.76	46070.0
2014-06-23 07:00:00	SPY	ETF	195.78	195.87	195.78	195.85	11550.0
2014-06-23 07:30:00	SPY	ETF	195.88	195.96	195.8	195.81	50498.0
2014-06-23 08:00:00	SPY	ETF	195.83	195.94	195.79	195.9	125157.0
2014-06-23 08:30:00	SPY	ETF	195.9	195.97	195.86	195.87	85733.0
2014-06-23 09:00:00	SPY	ETF	195.88	196.03	195.88	195.97	271747.0
2014-06-23 09:30:00	SPY	ETF	195.97	196.0	195.61	195.87	7551863.0
2014-06-23 10:00:00	SPY	ETF	195.87	196.05	195.76	195.88	6870856.0
2014-06-23 10:30:00	SPY	ETF	195.88	196.0	195.68	195.77	5716771.0
2014-06-23 11:00:00	SPY	ETF	195.765	195.815	195.58	195.59	4419416.0
2014-06-23 11:30:00	SPY	ETF	195.59	195.69	195.52	195.62	3484478.0
2014-06-23 12:00:00	SPY	ETF	195.62	195.86	195.61	195.78	1927557.0
2014-06-23 12:30:00	SPY	ETF	195.78	195.84	195.75	195.805	1746634.0
2014-06-23 13:00:00	SPY	ETF	195.81	195.82	195.59	195.6499	2276964.0
2014-06-23 13:30:00	SPY	ETF	195.65	195.745	195.57	195.7	2050745.0
2014-06-23 14:00:00	SPY	ETF	195.71	195.79	195.62	195.725	3117240.0
2014-06-23 14:30:00	SPY	ETF	195.73	195.8	195.66	195.79	1499402.0
2014-06-23 15:00:00	SPY	ETF	195.79	195.82	195.67	195.76	3470663.0
2014-06-23 15:30:00	SPY	ETF	195.77	195.96	195.74	195.882	6588676.0
2014-06-23 16:00:00	SPY	ETF	195.89	195.9371	195.76	195.82	14750684.0
2014-06-23 16:30:00	SPY	ETF	195.82	195.82	195.7	195.75	1140998.0
2014-06-23 17:00:00	SPY	ETF	195.74	195.75	195.69	195.72	32580.0
2014-06-23 17:30:00	SPY	ETF	195.72	195.73	195.7	195.7	5736.0
2014-06-23 18:00:00	SPY	ETF	195.67	195.68	195.57	195.62	83782.0
2014-06-23 18:30:00	SPY	ETF	195.6	195.65	195.6	195.65	26100.0
2014-06-23 19:00:00	SPY	ETF	195.64	195.67	195.63	195.64	5640.0
2014-06-23 19:30:00	SPY	ETF	195.64	195.69	195.57	195.67	45546.0
2014-06-23 04:00:00	QQQ	ETF	92.67	92.67	92.57	92.57	600.0
2014-06-23 05:30:00	QQQ	ETF	92.69	92.69	92.69	92.69	1200.0
2014-06-23 06:00:00	QQQ	ETF	92.67	92.67	92.67	92.67	1500.0
2014-06-23 06:30:00	QQQ	ETF	92.62	92.62	92.62	92.62	400.0
2014-06-23 07:00:00	QQQ	ETF	92.65	92.65	92.64	92.65	900.0
2014-06-23 07:30:00	QQQ	ETF	92.68	92.68	92.67	92.67	700.0
2014-06-23 08:00:00	QQQ	ETF	92.67	92.69	92.62	92.69	8100.0
2014-06-23 08:30:00	QQQ	ETF	92.68	92.71	92.67	92.68	34975.0
2014-06-23 09:00:00	QQQ	ETF	92.69	92.77	92.69	92.74	225147.0
2014-06-23 09:30:00	QQQ	ETF	92.735	92.8	92.5799	92.72	3221875.0
2014-06-23 10:00:00	QQQ	ETF	92.72	92.79	92.55	92.655	2579637.0
2014-06-23 10:30:00	QQQ	ETF	92.66	92.7	92.54	92.58	1634384.0
2014-06-23 11:00:00	QQQ	ETF	92.58	92.679	92.555	92.585	877484.0
2014-06-23 11:30:00	QQQ	ETF	92.59	92.67	92.51	92.6	1196502.0
2014-06-23 12:00:00	QQQ	ETF	92.595	92.765	92.59	92.765	624856.0
2014-06-23 12:30:00	QQQ	ETF	92.77	92.82	92.72	92.745	799927.0
2014-06-23 13:00:00	QQQ	ETF	92.75	92.78	92.61	92.66	622840.0
2014-06-23 13:30:00	QQQ	ETF	92.66	92.73	92.62	92.71	838475.0

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

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