PREVIEW / etf_30min / 2013-10-02

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-02.parquet
  size:    318 KB
  rows:    10,632

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-10-02 04:00:00	SPY	ETF	168.65	168.65	168.04	168.07	120923.0
2013-10-02 04:30:00	SPY	ETF	168.09	168.19	168.07	168.19	5600.0
2013-10-02 05:00:00	SPY	ETF	168.17	168.41	168.17	168.37	32531.0
2013-10-02 05:30:00	SPY	ETF	168.35	168.48	168.1	168.21	23289.0
2013-10-02 06:00:00	SPY	ETF	168.23	168.31	168.12	168.26	38028.0
2013-10-02 06:30:00	SPY	ETF	168.27	168.29	168.17	168.27	54141.0
2013-10-02 07:00:00	SPY	ETF	168.26	168.5	168.21	168.45	228480.0
2013-10-02 07:30:00	SPY	ETF	168.47	168.66	168.43	168.56	829767.0
2013-10-02 08:00:00	SPY	ETF	168.6186	168.95	168.13	168.17	1345923.0
2013-10-02 08:30:00	SPY	ETF	168.17	168.25	168.03	168.17	836860.0
2013-10-02 09:00:00	SPY	ETF	168.16	168.39	168.11	168.34	1353343.0
2013-10-02 09:30:00	SPY	ETF	168.35	169.3422	168.15	168.337	14576811.0
2013-10-02 10:00:00	SPY	ETF	168.33	168.39	167.83	168.06	10426168.0
2013-10-02 10:30:00	SPY	ETF	168.065	168.38	167.87	168.3	6971743.0
2013-10-02 11:00:00	SPY	ETF	168.3	168.67	168.25	168.565	6165013.0
2013-10-02 11:30:00	SPY	ETF	168.57	168.75	168.46	168.65	7850809.0
2013-10-02 12:00:00	SPY	ETF	168.65	168.93	168.65	168.72	3806852.0
2013-10-02 12:30:00	SPY	ETF	168.715	169.05	168.715	168.8973	3709019.0
2013-10-02 13:00:00	SPY	ETF	168.89	169.18	168.85	169.16	4088591.0
2013-10-02 13:30:00	SPY	ETF	169.14	169.21	169.02	169.025	4429528.0
2013-10-02 14:00:00	SPY	ETF	169.025	169.03	168.84	168.97	4057109.0
2013-10-02 14:30:00	SPY	ETF	168.97	169.02	168.68	168.79	4358703.0
2013-10-02 15:00:00	SPY	ETF	168.79	168.9	168.7	168.825	3463384.0
2013-10-02 15:30:00	SPY	ETF	168.82	169.21	168.73	169.15	12722639.0
2013-10-02 16:00:00	SPY	ETF	169.17	169.3422	168.74	168.83	14884340.0
2013-10-02 16:30:00	SPY	ETF	168.84	169.3422	168.7	168.83	4374694.0
2013-10-02 17:00:00	SPY	ETF	168.83	168.84	168.5615	168.79	1501318.0
2013-10-02 17:30:00	SPY	ETF	168.82	168.87	168.76	168.81	102999.0
2013-10-02 18:00:00	SPY	ETF	168.81	168.81	168.69	168.73	70978.0
2013-10-02 18:30:00	SPY	ETF	168.73	168.73	168.6	168.61	54525.0
2013-10-02 19:00:00	SPY	ETF	168.61	168.61	168.39	168.41	140276.0
2013-10-02 19:30:00	SPY	ETF	168.42	168.42	168.01	168.25	225089.0
2013-10-02 04:00:00	QQQ	ETF	79.33	79.33	79.12	79.13	46450.0
2013-10-02 04:30:00	QQQ	ETF	79.14	79.22	79.14	79.22	13100.0
2013-10-02 05:00:00	QQQ	ETF	79.23	79.32	79.23	79.3	11300.0
2013-10-02 05:30:00	QQQ	ETF	79.31	79.35	79.17	79.24	24150.0
2013-10-02 06:00:00	QQQ	ETF	79.25	79.29	79.2	79.24	29600.0
2013-10-02 06:30:00	QQQ	ETF	79.25	79.26	79.19	79.25	17650.0
2013-10-02 07:00:00	QQQ	ETF	79.23	79.35	79.22	79.35	37600.0
2013-10-02 07:30:00	QQQ	ETF	79.36	79.44	79.36	79.4	64390.0
2013-10-02 08:00:00	QQQ	ETF	79.4	79.44	79.21	79.22	256845.0
2013-10-02 08:30:00	QQQ	ETF	79.23	79.25	79.16	79.18	108671.0
2013-10-02 09:00:00	QQQ	ETF	79.18	79.22	79.1	79.13	125422.0
2013-10-02 09:30:00	QQQ	ETF	79.13	79.4599	79.11	79.389	3823816.0
2013-10-02 10:00:00	QQQ	ETF	79.38	79.415	79.06	79.27	2758193.0
2013-10-02 10:30:00	QQQ	ETF	79.27	79.46	79.175	79.37	1845187.0
2013-10-02 11:00:00	QQQ	ETF	79.37	79.54	79.35	79.44	1299916.0
2013-10-02 11:30:00	QQQ	ETF	79.44	79.56	79.385	79.51	1168699.0
2013-10-02 12:00:00	QQQ	ETF	79.51	79.63	79.471	79.505	847340.0
2013-10-02 12:30:00	QQQ	ETF	79.51	79.67	79.51	79.569	1047429.0

> showing 50 of 10,632 rows — these rows as CSV

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