PREVIEW / etf_30min / 2014-08-01

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-01.parquet
  size:    371 KB
  rows:    12,337

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-08-01 04:00:00	SPY	ETF	193.03	193.08	192.38	192.4	9478.0
2014-08-01 04:30:00	SPY	ETF	192.3	192.36	192.2	192.31	7641.0
2014-08-01 05:00:00	SPY	ETF	192.31	192.31	192.01	192.01	9952.0
2014-08-01 05:30:00	SPY	ETF	192.0	192.05	191.64	191.69	139426.0
2014-08-01 06:00:00	SPY	ETF	191.72	192.19	191.67	191.74	69691.0
2014-08-01 06:30:00	SPY	ETF	191.73	192.05	191.68	192.02	271433.0
2014-08-01 07:00:00	SPY	ETF	192.0	192.07	191.76	191.96	943597.0
2014-08-01 07:30:00	SPY	ETF	191.97	192.26	191.97	192.16	969289.0
2014-08-01 08:00:00	SPY	ETF	192.08	193.67	191.75	191.99	1995295.0
2014-08-01 08:30:00	SPY	ETF	191.93	193.21	191.89	192.76	7532386.0
2014-08-01 09:00:00	SPY	ETF	192.78	192.96	192.34	192.56	2458643.0
2014-08-01 09:30:00	SPY	ETF	192.56	193.54	192.46	193.41	21272747.0
2014-08-01 10:00:00	SPY	ETF	193.41	193.76	192.8	193.275	20372990.0
2014-08-01 10:30:00	SPY	ETF	193.275	193.41	192.75	192.87	10070645.0
2014-08-01 11:00:00	SPY	ETF	192.86	192.89	192.26	192.52	14306648.0
2014-08-01 11:30:00	SPY	ETF	192.52	192.7	191.57	191.7401	14172708.0
2014-08-01 12:00:00	SPY	ETF	191.74	192.18	191.7	191.93	11739098.0
2014-08-01 12:30:00	SPY	ETF	191.93	192.2	191.63	192.04	9160272.0
2014-08-01 13:00:00	SPY	ETF	192.03	192.77	191.78	192.77	9002403.0
2014-08-01 13:30:00	SPY	ETF	192.78	192.99	192.491	192.91	11114048.0
2014-08-01 14:00:00	SPY	ETF	192.92	193.2	192.72	192.85	7664035.0
2014-08-01 14:30:00	SPY	ETF	192.86	193.08	192.59	192.74	5732356.0
2014-08-01 15:00:00	SPY	ETF	192.75	193.03	192.64	192.79	7028840.0
2014-08-01 15:30:00	SPY	ETF	192.8	192.87	192.34	192.49	16532299.0
2014-08-01 16:00:00	SPY	ETF	192.51	193.098	192.33	192.38	8058678.0
2014-08-01 16:30:00	SPY	ETF	192.38	193.098	192.13	192.39	5423156.0
2014-08-01 17:00:00	SPY	ETF	192.37	192.4	192.27	192.32	125802.0
2014-08-01 17:30:00	SPY	ETF	192.34	192.37	192.19	192.2	153736.0
2014-08-01 18:00:00	SPY	ETF	192.2	192.25	192.2	192.25	96332.0
2014-08-01 18:30:00	SPY	ETF	192.25	192.27	192.2	192.22	17490.0
2014-08-01 19:00:00	SPY	ETF	192.21	192.4	192.2	192.38	39973.0
2014-08-01 19:30:00	SPY	ETF	192.34	192.38	192.33	192.34	15925.0
2014-08-01 04:00:00	QQQ	ETF	95.08	95.08	94.68	94.68	5900.0
2014-08-01 04:30:00	QQQ	ETF	94.55	94.6	94.55	94.6	9300.0
2014-08-01 05:00:00	QQQ	ETF	94.55	94.57	94.38	94.48	6200.0
2014-08-01 05:30:00	QQQ	ETF	94.4	94.4	94.2	94.26	42900.0
2014-08-01 06:00:00	QQQ	ETF	94.36	94.48	94.21	94.25	27350.0
2014-08-01 06:30:00	QQQ	ETF	94.27	94.37	94.25	94.35	6225.0
2014-08-01 07:00:00	QQQ	ETF	94.32	94.35	94.25	94.32	21800.0
2014-08-01 07:30:00	QQQ	ETF	94.37	94.55	94.37	94.54	64550.0
2014-08-01 08:00:00	QQQ	ETF	94.52	94.54	94.32	94.42	212821.0
2014-08-01 08:30:00	QQQ	ETF	94.43	95.04	94.43	94.89	1038127.0
2014-08-01 09:00:00	QQQ	ETF	94.9	94.97	94.73	94.83	327148.0
2014-08-01 09:30:00	QQQ	ETF	94.83	95.34	94.8	95.26	6782661.0
2014-08-01 10:00:00	QQQ	ETF	95.26	95.34	94.79	95.07	5095605.0
2014-08-01 10:30:00	QQQ	ETF	95.07	95.12	94.689	94.76	2446586.0
2014-08-01 11:00:00	QQQ	ETF	94.755	94.8	94.49	94.6	6974316.0
2014-08-01 11:30:00	QQQ	ETF	94.6	94.72	94.151	94.24	6200549.0
2014-08-01 12:00:00	QQQ	ETF	94.235	94.44	94.2	94.27	3587212.0
2014-08-01 12:30:00	QQQ	ETF	94.27	94.37	94.04	94.285	2983519.0

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

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