PREVIEW / etf_30min / 2015-02-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-06.parquet
  size:    390 KB
  rows:    12,996

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
2015-02-06 04:00:00	SPY	ETF	205.96	206.21	205.96	206.21	9400.0
2015-02-06 05:00:00	SPY	ETF	206.03	206.11	205.91	206.11	3300.0
2015-02-06 05:30:00	SPY	ETF	206.06	206.11	205.98	205.98	28762.0
2015-02-06 06:00:00	SPY	ETF	206.01	206.09	206.01	206.06	8706.0
2015-02-06 06:30:00	SPY	ETF	206.03	206.14	206.0	206.1	16475.0
2015-02-06 07:00:00	SPY	ETF	206.1	206.33	206.08	206.3	42716.0
2015-02-06 07:30:00	SPY	ETF	206.28	206.31	206.06	206.11	77070.0
2015-02-06 08:00:00	SPY	ETF	206.11	206.28	205.79	205.95	454831.0
2015-02-06 08:30:00	SPY	ETF	206.25	206.99	205.99	206.61	2844885.0
2015-02-06 09:00:00	SPY	ETF	206.6	206.73	206.43	206.55	1356005.0
2015-02-06 09:30:00	SPY	ETF	206.56	206.78	206.07	206.5	11609401.0
2015-02-06 10:00:00	SPY	ETF	206.5	206.97	206.48	206.7667	8087933.0
2015-02-06 10:30:00	SPY	ETF	206.765	207.24	206.76	207.01	6572951.0
2015-02-06 11:00:00	SPY	ETF	207.01	207.09	206.85	206.98	4665001.0
2015-02-06 11:30:00	SPY	ETF	206.98	207.18	206.76	207.04	5428857.0
2015-02-06 12:00:00	SPY	ETF	207.04	207.13	206.97	207.0399	3367960.0
2015-02-06 12:30:00	SPY	ETF	207.05	207.12	206.36	206.82	8244225.0
2015-02-06 13:00:00	SPY	ETF	206.82	206.89	205.73	206.02	9250072.0
2015-02-06 13:30:00	SPY	ETF	206.03	206.3699	205.73	206.2399	6772676.0
2015-02-06 14:00:00	SPY	ETF	206.24	206.39	205.95	206.29	5384585.0
2015-02-06 14:30:00	SPY	ETF	206.29	206.59	205.79	205.81	5937773.0
2015-02-06 15:00:00	SPY	ETF	205.81	205.83	205.01	205.06	13010386.0
2015-02-06 15:30:00	SPY	ETF	205.05	205.56	204.92	205.51	16373215.0
2015-02-06 16:00:00	SPY	ETF	205.55	206.15	205.4	205.75	9333448.0
2015-02-06 16:30:00	SPY	ETF	205.75	206.5811	205.515	205.92	4147973.0
2015-02-06 17:00:00	SPY	ETF	205.93	206.05	205.82	206.02	202869.0
2015-02-06 17:30:00	SPY	ETF	206.04	206.06	205.55	206.0	1536629.0
2015-02-06 18:00:00	SPY	ETF	206.02	206.05	205.95	206.01	38926.0
2015-02-06 18:30:00	SPY	ETF	205.99	205.99	205.95	205.95	12734.0
2015-02-06 19:00:00	SPY	ETF	205.99	206.0	205.95	205.96	10413.0
2015-02-06 19:30:00	SPY	ETF	205.97	206.04	205.96	206.04	26757.0
2015-02-06 04:00:00	QQQ	ETF	103.75	103.75	103.75	103.75	200.0
2015-02-06 04:30:00	QQQ	ETF	103.73	103.73	103.71	103.71	300.0
2015-02-06 06:30:00	QQQ	ETF	103.75	103.75	103.75	103.75	100.0
2015-02-06 07:00:00	QQQ	ETF	103.76	103.77	103.76	103.76	23500.0
2015-02-06 07:30:00	QQQ	ETF	103.75	103.75	103.69	103.69	30800.0
2015-02-06 08:00:00	QQQ	ETF	103.67	103.75	103.65	103.72	65477.0
2015-02-06 08:30:00	QQQ	ETF	103.8	104.01	103.76	103.93	238751.0
2015-02-06 09:00:00	QQQ	ETF	103.9	103.99	103.86	103.92	152440.0
2015-02-06 09:30:00	QQQ	ETF	103.92	103.94	103.42	103.69	3349754.0
2015-02-06 10:00:00	QQQ	ETF	103.69	103.92	103.63	103.8	3468668.0
2015-02-06 10:30:00	QQQ	ETF	103.82	104.17	103.79	104.0399	1515958.0
2015-02-06 11:00:00	QQQ	ETF	104.03	104.1137	103.951	104.07	1280595.0
2015-02-06 11:30:00	QQQ	ETF	104.07	104.15	103.97	104.0599	896836.0
2015-02-06 12:00:00	QQQ	ETF	104.06	104.1049	103.99	104.01	580198.0
2015-02-06 12:30:00	QQQ	ETF	104.02	104.04	103.62	103.86	2221332.0
2015-02-06 13:00:00	QQQ	ETF	103.861	103.89	103.25	103.389	2078047.0
2015-02-06 13:30:00	QQQ	ETF	103.38	103.59	103.25	103.53	1555522.0
2015-02-06 14:00:00	QQQ	ETF	103.53	103.69	103.39	103.635	1036932.0
2015-02-06 14:30:00	QQQ	ETF	103.64	103.7631	103.35	103.36	1364967.0

> showing 50 of 12,996 rows — these rows as CSV

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