PREVIEW / etf_30min / 2014-04-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-08.parquet
  size:    341 KB
  rows:    11,512

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-04-08 04:00:00	SPY	ETF	184.63	184.65	184.57	184.57	8990.0
2014-04-08 04:30:00	SPY	ETF	184.61	184.64	184.44	184.45	7344.0
2014-04-08 05:00:00	SPY	ETF	184.45	184.53	184.4	184.41	8581.0
2014-04-08 05:30:00	SPY	ETF	184.4	184.4	184.25	184.25	58990.0
2014-04-08 06:00:00	SPY	ETF	184.3	184.33	184.18	184.21	15261.0
2014-04-08 06:30:00	SPY	ETF	184.21	184.21	183.97	184.06	67642.0
2014-04-08 07:00:00	SPY	ETF	184.03	184.11	183.86	184.09	213086.0
2014-04-08 07:30:00	SPY	ETF	184.08	184.19	183.94	183.98	124249.0
2014-04-08 08:00:00	SPY	ETF	184.1	184.32	184.0	184.25	465958.0
2014-04-08 08:30:00	SPY	ETF	184.24	184.52	184.23	184.4	1639554.0
2014-04-08 09:00:00	SPY	ETF	184.39	184.42	184.2	184.2	821104.0
2014-04-08 09:30:00	SPY	ETF	184.21	184.76	184.06	184.2	15550642.0
2014-04-08 10:00:00	SPY	ETF	184.2	184.59	183.59	183.6	12618685.0
2014-04-08 10:30:00	SPY	ETF	183.5999	184.68	183.599	184.54	12287215.0
2014-04-08 11:00:00	SPY	ETF	184.55	185.2	184.55	184.98	11075745.0
2014-04-08 11:30:00	SPY	ETF	184.98	185.09	184.64	185.02	6139462.0
2014-04-08 12:00:00	SPY	ETF	185.01	185.15	184.84	185.14	4224285.0
2014-04-08 12:30:00	SPY	ETF	185.13	185.17	184.77	184.79	3856994.0
2014-04-08 13:00:00	SPY	ETF	184.781	185.4	184.78	185.3	5391623.0
2014-04-08 13:30:00	SPY	ETF	185.31	185.33	185.06	185.29	3560666.0
2014-04-08 14:00:00	SPY	ETF	185.28	185.32	184.69	184.81	6116437.0
2014-04-08 14:30:00	SPY	ETF	184.82	185.0	184.62	184.91	5392510.0
2014-04-08 15:00:00	SPY	ETF	184.9	185.15	184.69	185.08	4599943.0
2014-04-08 15:30:00	SPY	ETF	185.08	185.28	185.0	185.11	11719712.0
2014-04-08 16:00:00	SPY	ETF	185.11	185.205	184.3764	185.02	3621226.0
2014-04-08 16:30:00	SPY	ETF	185.02	185.05	184.99	185.02	1179270.0
2014-04-08 17:00:00	SPY	ETF	185.02	185.07	184.3764	185.07	1067863.0
2014-04-08 17:30:00	SPY	ETF	185.06	185.07	185.04	185.04	31932.0
2014-04-08 18:00:00	SPY	ETF	185.04	185.09	185.02	185.06	28204.0
2014-04-08 18:30:00	SPY	ETF	185.05	185.06	185.02	185.06	7750.0
2014-04-08 19:00:00	SPY	ETF	185.04	185.07	185.04	185.07	14407.0
2014-04-08 19:30:00	SPY	ETF	185.07	185.11	185.07	185.1	22902.0
2014-04-08 04:00:00	QQQ	ETF	85.74	85.78	85.74	85.76	3700.0
2014-04-08 04:30:00	QQQ	ETF	85.75	85.78	85.67	85.67	3850.0
2014-04-08 05:00:00	QQQ	ETF	85.68	85.75	85.64	85.66	4800.0
2014-04-08 05:30:00	QQQ	ETF	85.65	85.67	85.58	85.6	13697.0
2014-04-08 06:00:00	QQQ	ETF	85.63	85.65	85.57	85.59	4235.0
2014-04-08 06:30:00	QQQ	ETF	85.58	85.58	85.48	85.48	16000.0
2014-04-08 07:00:00	QQQ	ETF	85.46	85.55	85.42	85.55	24512.0
2014-04-08 07:30:00	QQQ	ETF	85.55	85.6	85.46	85.47	99600.0
2014-04-08 08:00:00	QQQ	ETF	85.51	85.68	85.44	85.65	200610.0
2014-04-08 08:30:00	QQQ	ETF	85.66	85.83	85.64	85.73	239240.0
2014-04-08 09:00:00	QQQ	ETF	85.72	85.73	85.62	85.63	183196.0
2014-04-08 09:30:00	QQQ	ETF	85.65	86.08	85.42	85.67	10074465.0
2014-04-08 10:00:00	QQQ	ETF	85.66	85.97	85.35	85.36	5215133.0
2014-04-08 10:30:00	QQQ	ETF	85.36	86.25	85.355	86.13	6635134.0
2014-04-08 11:00:00	QQQ	ETF	86.13	86.46	86.13	86.32	7118888.0
2014-04-08 11:30:00	QQQ	ETF	86.32	86.4	86.02	86.21	2766112.0
2014-04-08 12:00:00	QQQ	ETF	86.22	86.42	86.12	86.42	1411072.0
2014-04-08 12:30:00	QQQ	ETF	86.42	86.431	86.22	86.2356	1954415.0

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

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