PREVIEW / etf_30min / 2013-05-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-06.parquet
  size:    311 KB
  rows:    10,681

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-05-06 04:00:00	SPY	ETF	161.37	161.51	161.37	161.51	900.0
2013-05-06 04:30:00	SPY	ETF	161.52	161.52	161.52	161.52	300.0
2013-05-06 05:00:00	SPY	ETF	161.51	161.51	161.43	161.43	2300.0
2013-05-06 05:30:00	SPY	ETF	161.36	161.38	161.36	161.38	399.0
2013-05-06 06:00:00	SPY	ETF	161.33	161.4	161.33	161.4	3200.0
2013-05-06 06:30:00	SPY	ETF	161.39	161.39	161.2	161.27	16099.0
2013-05-06 07:00:00	SPY	ETF	161.23	161.31	161.23	161.31	22485.0
2013-05-06 07:30:00	SPY	ETF	161.31	161.31	161.22	161.3	118292.0
2013-05-06 08:00:00	SPY	ETF	161.31	161.36	161.25	161.31	126127.0
2013-05-06 08:30:00	SPY	ETF	161.34	161.51	161.33	161.43	288656.0
2013-05-06 09:00:00	SPY	ETF	161.44	161.52	161.39	161.5	444785.0
2013-05-06 09:30:00	SPY	ETF	161.49	161.72	161.42	161.48	9200428.0
2013-05-06 10:00:00	SPY	ETF	161.48	161.82	161.47	161.77	7626990.0
2013-05-06 10:30:00	SPY	ETF	161.779	161.84	161.46	161.52	5655289.0
2013-05-06 11:00:00	SPY	ETF	161.51	161.6401	161.46	161.61	3505814.0
2013-05-06 11:30:00	SPY	ETF	161.6	161.79	161.48	161.7599	3684679.0
2013-05-06 12:00:00	SPY	ETF	161.75	161.87	161.73	161.78	3456944.0
2013-05-06 12:30:00	SPY	ETF	161.7799	161.87	161.74	161.799	2295900.0
2013-05-06 13:00:00	SPY	ETF	161.8	161.85	161.74	161.835	3234923.0
2013-05-06 13:30:00	SPY	ETF	161.83	161.99	161.82	161.98	3063243.0
2013-05-06 14:00:00	SPY	ETF	161.97	162.01	161.91	161.97	2325627.0
2013-05-06 14:30:00	SPY	ETF	161.96	161.97	161.87	161.88	2964846.0
2013-05-06 15:00:00	SPY	ETF	161.8801	161.92	161.76	161.79	2808365.0
2013-05-06 15:30:00	SPY	ETF	161.79	161.91	161.69	161.79	9125549.0
2013-05-06 16:00:00	SPY	ETF	161.79	161.85	161.45	161.83	2765570.0
2013-05-06 16:30:00	SPY	ETF	161.83	161.84	161.75	161.77	160242.0
2013-05-06 17:00:00	SPY	ETF	161.78	161.78	161.74	161.75	36512.0
2013-05-06 17:30:00	SPY	ETF	161.76	161.82	161.76	161.8	29800.0
2013-05-06 18:00:00	SPY	ETF	161.78	161.78	161.64	161.64	96620.0
2013-05-06 18:30:00	SPY	ETF	161.65	161.68	161.63	161.68	21669.0
2013-05-06 19:00:00	SPY	ETF	161.67	161.7	161.65	161.65	3967.0
2013-05-06 19:30:00	SPY	ETF	161.68	161.68	161.58	161.6	40102.0
2013-05-06 04:00:00	QQQ	ETF	72.25	72.25	72.19	72.19	23009.0
2013-05-06 06:00:00	QQQ	ETF	72.16	72.16	72.16	72.16	596.0
2013-05-06 06:30:00	QQQ	ETF	72.11	72.11	72.1	72.1	1600.0
2013-05-06 07:00:00	QQQ	ETF	72.1	72.12	72.1	72.12	1304.0
2013-05-06 07:30:00	QQQ	ETF	72.1	72.13	72.1	72.13	2600.0
2013-05-06 08:00:00	QQQ	ETF	72.11	72.5	72.11	72.15	61333.0
2013-05-06 08:30:00	QQQ	ETF	72.17	72.27	72.17	72.23	143941.0
2013-05-06 09:00:00	QQQ	ETF	72.23	72.29	72.22	72.25	140636.0
2013-05-06 09:30:00	QQQ	ETF	72.25	72.39	72.19	72.3	2813373.0
2013-05-06 10:00:00	QQQ	ETF	72.3	72.39	72.25	72.34	2050412.0
2013-05-06 10:30:00	QQQ	ETF	72.3401	72.43	72.21	72.23	2755665.0
2013-05-06 11:00:00	QQQ	ETF	72.22	72.3299	72.2	72.3	1038469.0
2013-05-06 11:30:00	QQQ	ETF	72.3	72.43	72.2447	72.42	814465.0
2013-05-06 12:00:00	QQQ	ETF	72.42	72.45	72.38	72.38	714740.0
2013-05-06 12:30:00	QQQ	ETF	72.385	72.42	72.355	72.4	499472.0
2013-05-06 13:00:00	QQQ	ETF	72.409	72.429	72.36	72.425	457512.0
2013-05-06 13:30:00	QQQ	ETF	72.425	72.51	72.42	72.5	744781.0
2013-05-06 14:00:00	QQQ	ETF	72.49	72.51	72.46	72.4699	943382.0

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

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