PREVIEW / etf_30min / 2013-05-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-10.parquet
  size:    315 KB
  rows:    10,643

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-10 04:00:00	SPY	ETF	163.3	163.52	163.26	163.26	41283.0
2013-05-10 04:30:00	SPY	ETF	163.26	163.26	163.05	163.13	19500.0
2013-05-10 05:00:00	SPY	ETF	163.13	163.13	162.99	163.1	16100.0
2013-05-10 05:30:00	SPY	ETF	163.1	163.19	163.08	163.19	2100.0
2013-05-10 06:00:00	SPY	ETF	163.21	163.24	163.2	163.24	24500.0
2013-05-10 06:30:00	SPY	ETF	163.25	163.35	163.18	163.32	31599.0
2013-05-10 07:00:00	SPY	ETF	163.32	163.32	163.1	163.15	108614.0
2013-05-10 07:30:00	SPY	ETF	163.11	163.17	162.97	163.11	250346.0
2013-05-10 08:00:00	SPY	ETF	163.21	163.21	162.94	163.04	496636.0
2013-05-10 08:30:00	SPY	ETF	163.04	163.42	162.97	163.06	265409.0
2013-05-10 09:00:00	SPY	ETF	163.04	163.16	162.86	162.99	672773.0
2013-05-10 09:30:00	SPY	ETF	162.99	163.3	162.79	163.25	11211552.0
2013-05-10 10:00:00	SPY	ETF	163.241	163.4	163.07	163.082	8131431.0
2013-05-10 10:30:00	SPY	ETF	163.081	163.09	162.61	162.91	10333724.0
2013-05-10 11:00:00	SPY	ETF	162.92	163.1	162.8	163.07	6539092.0
2013-05-10 11:30:00	SPY	ETF	163.07	163.22	162.64	162.65	6842602.0
2013-05-10 12:00:00	SPY	ETF	162.65	162.87	162.51	162.81	5416928.0
2013-05-10 12:30:00	SPY	ETF	162.82	162.96	162.75	162.83	4335462.0
2013-05-10 13:00:00	SPY	ETF	162.825	163.11	162.82	163.0676	4514486.0
2013-05-10 13:30:00	SPY	ETF	163.07	163.1099	162.91	162.93	6898274.0
2013-05-10 14:00:00	SPY	ETF	162.935	163.17	162.93	163.11	3444480.0
2013-05-10 14:30:00	SPY	ETF	163.115	163.17	163.03	163.05	2651658.0
2013-05-10 15:00:00	SPY	ETF	163.051	163.21	163.05	163.095	7873236.0
2013-05-10 15:30:00	SPY	ETF	163.09	163.49	163.07	163.45	12963384.0
2013-05-10 16:00:00	SPY	ETF	163.45	163.5515	162.79	163.46	4946238.0
2013-05-10 16:30:00	SPY	ETF	163.47	163.5	163.41	163.41	328657.0
2013-05-10 17:00:00	SPY	ETF	163.43	163.49	163.42	163.42	43844.0
2013-05-10 17:30:00	SPY	ETF	163.45	163.48	163.36	163.36	52070.0
2013-05-10 18:00:00	SPY	ETF	163.4	163.47	163.4	163.47	9654.0
2013-05-10 18:30:00	SPY	ETF	163.46	163.46	163.45	163.45	3400.0
2013-05-10 19:00:00	SPY	ETF	163.47	163.47	163.34	163.41	57787.0
2013-05-10 19:30:00	SPY	ETF	163.35	163.38	163.21	163.25	56237.0
2013-05-10 04:00:00	QQQ	ETF	72.9	72.9	72.9	72.9	100.0
2013-05-10 05:00:00	QQQ	ETF	72.68	72.68	72.68	72.68	400.0
2013-05-10 06:00:00	QQQ	ETF	72.72	72.72	72.72	72.72	200.0
2013-05-10 06:30:00	QQQ	ETF	72.76	72.79	72.74	72.78	2500.0
2013-05-10 07:00:00	QQQ	ETF	72.75	72.75	72.71	72.73	3300.0
2013-05-10 07:30:00	QQQ	ETF	72.73	72.73	72.68	72.71	42700.0
2013-05-10 08:00:00	QQQ	ETF	72.71	72.74	72.69	72.71	12795.0
2013-05-10 08:30:00	QQQ	ETF	72.7	72.75	72.68	72.71	22495.0
2013-05-10 09:00:00	QQQ	ETF	72.68	72.76	72.67	72.7	82780.0
2013-05-10 09:30:00	QQQ	ETF	72.72	72.99	72.63	72.96	3206091.0
2013-05-10 10:00:00	QQQ	ETF	72.97	73.059	72.86	72.87	1736773.0
2013-05-10 10:30:00	QQQ	ETF	72.86	72.8601	72.64	72.7991	2289599.0
2013-05-10 11:00:00	QQQ	ETF	72.8	72.895	72.71	72.85	2133122.0
2013-05-10 11:30:00	QQQ	ETF	72.86	72.9399	72.69	72.691	1052004.0
2013-05-10 12:00:00	QQQ	ETF	72.69	72.78	72.64	72.77	1100032.0
2013-05-10 12:30:00	QQQ	ETF	72.77	72.81	72.72	72.77	538610.0
2013-05-10 13:00:00	QQQ	ETF	72.77	72.92	72.77	72.89	636266.0
2013-05-10 13:30:00	QQQ	ETF	72.9	72.91	72.81	72.85	1038941.0

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

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