PREVIEW / etf_30min / 2014-01-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-15.parquet
  size:    337 KB
  rows:    11,560

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-01-15 04:00:00	SPY	ETF	183.93	183.94	183.89	183.89	3510.0
2014-01-15 04:30:00	SPY	ETF	183.97	183.99	183.89	183.9	11999.0
2014-01-15 05:00:00	SPY	ETF	183.9	183.9	183.86	183.88	1010.0
2014-01-15 05:30:00	SPY	ETF	183.91	183.95	183.91	183.91	3502.0
2014-01-15 06:00:00	SPY	ETF	183.99	184.02	183.96	184.02	53200.0
2014-01-15 06:30:00	SPY	ETF	184.05	184.13	184.01	184.01	43942.0
2014-01-15 07:00:00	SPY	ETF	184.04	184.1	184.0	184.1	136118.0
2014-01-15 07:30:00	SPY	ETF	184.09	184.1	183.99	183.99	358875.0
2014-01-15 08:00:00	SPY	ETF	184.08	184.08	183.94	183.99	627341.0
2014-01-15 08:30:00	SPY	ETF	183.99	184.01	183.8	184.0	760871.0
2014-01-15 09:00:00	SPY	ETF	184.01	184.18	183.98	184.11	777655.0
2014-01-15 09:30:00	SPY	ETF	184.1	184.32	184.01	184.25	9651457.0
2014-01-15 10:00:00	SPY	ETF	184.24	184.67	184.23	184.61	10083672.0
2014-01-15 10:30:00	SPY	ETF	184.62	184.69	184.39	184.52	5161315.0
2014-01-15 11:00:00	SPY	ETF	184.53	184.94	184.44	184.52	8796497.0
2014-01-15 11:30:00	SPY	ETF	184.525	184.66	184.48	184.6	3391898.0
2014-01-15 12:00:00	SPY	ETF	184.61	184.83	184.61	184.75	3718681.0
2014-01-15 12:30:00	SPY	ETF	184.76	184.77	184.52	184.66	3102544.0
2014-01-15 13:00:00	SPY	ETF	184.66	184.7599	184.4498	184.515	2889988.0
2014-01-15 13:30:00	SPY	ETF	184.51	184.61	184.4	184.45	8293000.0
2014-01-15 14:00:00	SPY	ETF	184.45	184.77	184.36	184.68	5166799.0
2014-01-15 14:30:00	SPY	ETF	184.6734	184.82	184.6	184.79	2659728.0
2014-01-15 15:00:00	SPY	ETF	184.8	184.86	184.48	184.62	8164879.0
2014-01-15 15:30:00	SPY	ETF	184.62	184.76	184.57	184.67	12868549.0
2014-01-15 16:00:00	SPY	ETF	184.67	184.69	183.7102	184.55	4021795.0
2014-01-15 16:30:00	SPY	ETF	184.53	184.59	183.7102	184.54	4280664.0
2014-01-15 17:00:00	SPY	ETF	184.54	184.57	184.52	184.55	39866.0
2014-01-15 17:30:00	SPY	ETF	184.55	184.55	184.49	184.51	1033606.0
2014-01-15 18:00:00	SPY	ETF	184.55	184.57	184.48	184.54	21904.0
2014-01-15 18:30:00	SPY	ETF	184.53	184.6	184.53	184.6	44012.0
2014-01-15 19:00:00	SPY	ETF	184.62	184.71	184.62	184.7	51479.0
2014-01-15 19:30:00	SPY	ETF	184.7	184.7	184.65	184.7	36832.0
2014-01-15 04:00:00	QQQ	ETF	87.76	87.88	87.76	87.88	800.0
2014-01-15 04:30:00	QQQ	ETF	87.93	87.93	87.89	87.89	860.0
2014-01-15 06:00:00	QQQ	ETF	87.95	87.95	87.95	87.95	1500.0
2014-01-15 06:30:00	QQQ	ETF	87.98	88.01	87.95	87.95	12040.0
2014-01-15 07:00:00	QQQ	ETF	87.95	87.97	87.95	87.97	6300.0
2014-01-15 07:30:00	QQQ	ETF	87.98	87.99	87.97	87.97	16000.0
2014-01-15 08:00:00	QQQ	ETF	87.97	87.99	87.95	87.951	76309.0
2014-01-15 08:30:00	QQQ	ETF	87.96	87.99	87.9	87.98	324169.0
2014-01-15 09:00:00	QQQ	ETF	87.97	88.03	87.96	88.01	277754.0
2014-01-15 09:30:00	QQQ	ETF	88.0	88.238	87.94	88.195	6018389.0
2014-01-15 10:00:00	QQQ	ETF	88.199	88.38	88.195	88.3	5719978.0
2014-01-15 10:30:00	QQQ	ETF	88.3	88.35	88.145	88.225	1849297.0
2014-01-15 11:00:00	QQQ	ETF	88.23	88.49	88.17	88.255	1835222.0
2014-01-15 11:30:00	QQQ	ETF	88.26	88.36	88.25	88.32	931656.0
2014-01-15 12:00:00	QQQ	ETF	88.32	88.469	88.32	88.42	680525.0
2014-01-15 12:30:00	QQQ	ETF	88.43	88.44	88.33	88.3601	977096.0
2014-01-15 13:00:00	QQQ	ETF	88.365	88.436	88.29	88.33	758208.0
2014-01-15 13:30:00	QQQ	ETF	88.33	88.37	88.26	88.32	1134224.0

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

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