PREVIEW / etf_30min / 2014-05-14

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-14.parquet
  size:    329 KB
  rows:    11,227

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-05-14 04:00:00	SPY	ETF	189.9	189.93	189.9	189.93	845.0
2014-05-14 04:30:00	SPY	ETF	189.93	189.93	189.83	189.91	4233.0
2014-05-14 05:00:00	SPY	ETF	189.91	190.01	189.88	189.88	8036.0
2014-05-14 05:30:00	SPY	ETF	189.88	189.92	189.81	189.81	5325.0
2014-05-14 06:00:00	SPY	ETF	189.8	189.83	189.76	189.83	23351.0
2014-05-14 06:30:00	SPY	ETF	189.79	189.82	189.7	189.75	12641.0
2014-05-14 07:00:00	SPY	ETF	189.77	189.84	189.62	189.64	137170.0
2014-05-14 07:30:00	SPY	ETF	189.66	189.74	189.66	189.68	184179.0
2014-05-14 08:00:00	SPY	ETF	189.71	189.74	189.63	189.64	191874.0
2014-05-14 08:30:00	SPY	ETF	189.65	189.77	189.62	189.66	157527.0
2014-05-14 09:00:00	SPY	ETF	189.64	189.86	189.64	189.79	405098.0
2014-05-14 09:30:00	SPY	ETF	189.79	189.88	189.4	189.69	9542897.0
2014-05-14 10:00:00	SPY	ETF	189.7	189.84	189.34	189.63	5732668.0
2014-05-14 10:30:00	SPY	ETF	189.63	189.79	189.41	189.5	4484511.0
2014-05-14 11:00:00	SPY	ETF	189.505	189.62	189.4	189.545	3935858.0
2014-05-14 11:30:00	SPY	ETF	189.56	189.72	189.5	189.515	3507664.0
2014-05-14 12:00:00	SPY	ETF	189.515	189.66	189.5	189.57	1818595.0
2014-05-14 12:30:00	SPY	ETF	189.565	189.68	189.49	189.6	2783824.0
2014-05-14 13:00:00	SPY	ETF	189.591	189.74	189.59	189.62	1713420.0
2014-05-14 13:30:00	SPY	ETF	189.621	189.66	189.56	189.64	1521254.0
2014-05-14 14:00:00	SPY	ETF	189.64	189.65	189.52	189.5922	1927543.0
2014-05-14 14:30:00	SPY	ETF	189.59	189.64	189.17	189.235	5921194.0
2014-05-14 15:00:00	SPY	ETF	189.24	189.26	188.98	189.12	6722401.0
2014-05-14 15:30:00	SPY	ETF	189.12	189.14	188.79	189.05	14987049.0
2014-05-14 16:00:00	SPY	ETF	189.06	189.15	189.0	189.11	4068959.0
2014-05-14 16:30:00	SPY	ETF	189.12	189.13	189.0	189.11	1142230.0
2014-05-14 17:00:00	SPY	ETF	189.1	189.18	189.1	189.16	62074.0
2014-05-14 17:30:00	SPY	ETF	189.17	189.2	189.14	189.16	11177.0
2014-05-14 18:00:00	SPY	ETF	189.19	189.2	189.13	189.14	25528.0
2014-05-14 18:30:00	SPY	ETF	189.14	189.16	189.1	189.15	7930.0
2014-05-14 19:00:00	SPY	ETF	189.13	189.15	189.12	189.14	16940.0
2014-05-14 19:30:00	SPY	ETF	189.17	189.18	189.03	189.05	72322.0
2014-05-14 04:00:00	QQQ	ETF	88.23	88.23	88.2	88.2	2500.0
2014-05-14 05:30:00	QQQ	ETF	88.13	88.13	88.13	88.13	2500.0
2014-05-14 06:00:00	QQQ	ETF	88.1	88.15	88.1	88.15	200.0
2014-05-14 06:30:00	QQQ	ETF	88.13	88.15	88.08	88.15	870.0
2014-05-14 07:00:00	QQQ	ETF	88.11	88.12	88.05	88.07	13860.0
2014-05-14 07:30:00	QQQ	ETF	88.1	88.1	88.06	88.08	17500.0
2014-05-14 08:00:00	QQQ	ETF	88.07	88.15	88.02	88.02	39750.0
2014-05-14 08:30:00	QQQ	ETF	88.02	88.29	87.945	87.95	275155.0
2014-05-14 09:00:00	QQQ	ETF	87.94	88.05	87.93	88.02	102305.0
2014-05-14 09:30:00	QQQ	ETF	88.03	88.27	87.9201	88.24	4440168.0
2014-05-14 10:00:00	QQQ	ETF	88.25	88.35	87.98	88.22	2641372.0
2014-05-14 10:30:00	QQQ	ETF	88.22	88.32	88.09	88.141	1479507.0
2014-05-14 11:00:00	QQQ	ETF	88.15	88.21	87.9901	88.02	961055.0
2014-05-14 11:30:00	QQQ	ETF	88.03	88.2	88.0	88.0749	835693.0
2014-05-14 12:00:00	QQQ	ETF	88.07	88.19	88.07	88.15	586788.0
2014-05-14 12:30:00	QQQ	ETF	88.15	88.23	88.08	88.18	774609.0
2014-05-14 13:00:00	QQQ	ETF	88.18	88.32	88.18	88.24	1164963.0
2014-05-14 13:30:00	QQQ	ETF	88.25	88.27	88.18	88.21	514645.0

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

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