PREVIEW / etf_30min / 2013-07-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-23.parquet
  size:    312 KB
  rows:    10,789

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-07-23 04:00:00	SPY	ETF	169.71	169.72	169.65	169.68	7250.0
2013-07-23 04:30:00	SPY	ETF	169.68	169.8	169.65	169.8	2000.0
2013-07-23 05:00:00	SPY	ETF	169.75	169.75	169.7	169.75	2100.0
2013-07-23 05:30:00	SPY	ETF	169.78	169.8	169.75	169.79	8900.0
2013-07-23 06:00:00	SPY	ETF	169.75	169.75	169.73	169.73	1400.0
2013-07-23 06:30:00	SPY	ETF	169.72	169.85	169.72	169.84	75400.0
2013-07-23 07:00:00	SPY	ETF	169.81	169.84	169.7	169.7	27314.0
2013-07-23 07:30:00	SPY	ETF	169.65	169.82	169.65	169.8	95120.0
2013-07-23 08:00:00	SPY	ETF	169.81	169.82	169.69	169.7	100319.0
2013-07-23 08:30:00	SPY	ETF	169.7	169.77	169.67	169.7	263892.0
2013-07-23 09:00:00	SPY	ETF	169.7	169.87	169.4976	169.79	485489.0
2013-07-23 09:30:00	SPY	ETF	169.8	169.83	169.55	169.63	10879406.0
2013-07-23 10:00:00	SPY	ETF	169.63	169.64	169.3	169.33	9142600.0
2013-07-23 10:30:00	SPY	ETF	169.32	169.33	169.12	169.145	6511503.0
2013-07-23 11:00:00	SPY	ETF	169.145	169.32	169.05	169.29	4662449.0
2013-07-23 11:30:00	SPY	ETF	169.29	169.4	169.19	169.3	4187774.0
2013-07-23 12:00:00	SPY	ETF	169.29	169.38	169.17	169.315	2663731.0
2013-07-23 12:30:00	SPY	ETF	169.315	169.33	169.19	169.23	2269953.0
2013-07-23 13:00:00	SPY	ETF	169.235	169.5	169.23	169.43	3783774.0
2013-07-23 13:30:00	SPY	ETF	169.435	169.52	169.34	169.37	3037202.0
2013-07-23 14:00:00	SPY	ETF	169.37	169.46	169.35	169.39	2480138.0
2013-07-23 14:30:00	SPY	ETF	169.39	169.6	169.37	169.55	4713028.0
2013-07-23 15:00:00	SPY	ETF	169.55	169.55	169.38	169.439	3384794.0
2013-07-23 15:30:00	SPY	ETF	169.44	169.48	169.09	169.23	11674229.0
2013-07-23 16:00:00	SPY	ETF	169.23	169.4976	169.14	169.2	6338182.0
2013-07-23 16:30:00	SPY	ETF	169.28	169.54	169.22	169.47	508007.0
2013-07-23 17:00:00	SPY	ETF	169.48	169.48	169.32	169.4	582870.0
2013-07-23 17:30:00	SPY	ETF	169.36	169.37	169.33	169.33	9001.0
2013-07-23 18:00:00	SPY	ETF	169.39	169.4	169.21	169.29	23502.0
2013-07-23 18:30:00	SPY	ETF	169.26	169.36	169.26	169.36	20393.0
2013-07-23 19:00:00	SPY	ETF	169.33	169.35	169.33	169.34	681.0
2013-07-23 19:30:00	SPY	ETF	169.36	169.39	169.34	169.38	19560.0
2013-07-23 04:00:00	QQQ	ETF	74.89	74.91	74.88	74.89	5000.0
2013-07-23 04:30:00	QQQ	ETF	74.87	74.95	74.87	74.95	3000.0
2013-07-23 05:00:00	QQQ	ETF	74.93	74.93	74.91	74.93	2708.0
2013-07-23 05:30:00	QQQ	ETF	74.92	74.95	74.92	74.95	2414.0
2013-07-23 06:00:00	QQQ	ETF	74.93	74.93	74.93	74.93	600.0
2013-07-23 06:30:00	QQQ	ETF	74.95	75.0	74.95	75.0	3177.0
2013-07-23 07:00:00	QQQ	ETF	74.99	75.0	74.93	74.93	8265.0
2013-07-23 07:30:00	QQQ	ETF	74.94	74.97	74.93	74.96	6150.0
2013-07-23 08:00:00	QQQ	ETF	74.97	74.97	74.87	74.87	23600.0
2013-07-23 08:30:00	QQQ	ETF	74.87	74.91	74.87	74.89	33000.0
2013-07-23 09:00:00	QQQ	ETF	74.9	74.95	74.85	74.94	45466.0
2013-07-23 09:30:00	QQQ	ETF	74.95	74.96	74.72	74.72	2036032.0
2013-07-23 10:00:00	QQQ	ETF	74.725	74.725	74.4706	74.49	1977411.0
2013-07-23 10:30:00	QQQ	ETF	74.49	74.519	74.39	74.42	1508873.0
2013-07-23 11:00:00	QQQ	ETF	74.42	74.56	74.3801	74.55	1191758.0
2013-07-23 11:30:00	QQQ	ETF	74.55	74.56	74.47	74.51	695162.0
2013-07-23 12:00:00	QQQ	ETF	74.505	74.54	74.44	74.47	567783.0
2013-07-23 12:30:00	QQQ	ETF	74.47	74.5	74.4	74.446	1185586.0

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

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