PREVIEW / etf_30min / 2011-11-10

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-10.parquet
  size:    277 KB
  rows:    9,324

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
2011-11-10 04:00:00	SPY	ETF	123.5	124.05	123.5	124.03	11733.0
2011-11-10 04:30:00	SPY	ETF	124.12	124.77	123.95	124.56	59379.0
2011-11-10 05:00:00	SPY	ETF	124.77	124.87	124.17	124.17	34509.0
2011-11-10 05:30:00	SPY	ETF	124.15	124.32	123.72	124.32	71166.0
2011-11-10 06:00:00	SPY	ETF	124.1	124.24	123.9	124.14	31683.0
2011-11-10 06:30:00	SPY	ETF	124.08	124.61	124.04	124.61	144917.0
2011-11-10 07:00:00	SPY	ETF	124.55	124.64	124.31	124.46	680698.0
2011-11-10 07:30:00	SPY	ETF	124.45	125.03	124.45	124.77	1022947.0
2011-11-10 08:00:00	SPY	ETF	123.98	124.96	123.85	124.86	1562238.0
2011-11-10 08:30:00	SPY	ETF	124.86	125.05	124.64	124.91	2406270.0
2011-11-10 09:00:00	SPY	ETF	124.91	124.94	123.19	124.79	2377777.0
2011-11-10 09:30:00	SPY	ETF	124.79	124.85	123.9	123.96	25262054.0
2011-11-10 10:00:00	SPY	ETF	123.96	124.32	123.58	123.58	25482474.0
2011-11-10 10:30:00	SPY	ETF	123.58	123.9345	123.02	123.42	19396215.0
2011-11-10 11:00:00	SPY	ETF	123.42	123.89	123.34	123.71	14511144.0
2011-11-10 11:30:00	SPY	ETF	123.68	124.47	123.57	124.18	18383527.0
2011-11-10 12:00:00	SPY	ETF	124.19	124.39	123.96	123.99	9719604.0
2011-11-10 12:30:00	SPY	ETF	123.98	124.32	123.65	124.2407	9301537.0
2011-11-10 13:00:00	SPY	ETF	124.25	124.94	124.18	124.611	16680350.0
2011-11-10 13:30:00	SPY	ETF	124.61	124.82	124.36	124.65	8454212.0
2011-11-10 14:00:00	SPY	ETF	124.65	124.72	124.09	124.17	11739233.0
2011-11-10 14:30:00	SPY	ETF	124.18	124.39	123.79	123.797	11147375.0
2011-11-10 15:00:00	SPY	ETF	123.8	124.51	123.75	124.34	17251219.0
2011-11-10 15:30:00	SPY	ETF	124.35	124.56	123.99	124.25	22876006.0
2011-11-10 16:00:00	SPY	ETF	124.28	124.4	123.1863	124.29	10808606.0
2011-11-10 16:30:00	SPY	ETF	124.29	124.44	123.1863	124.42	1408903.0
2011-11-10 17:00:00	SPY	ETF	124.41	124.5	124.41	124.41	148959.0
2011-11-10 17:30:00	SPY	ETF	124.37	124.43	124.35	124.37	17414.0
2011-11-10 18:00:00	SPY	ETF	124.35	124.35	124.2	124.2	191251.0
2011-11-10 18:30:00	SPY	ETF	124.21	124.46	124.18	124.28	57632.0
2011-11-10 19:00:00	SPY	ETF	124.3	124.43	124.08	124.16	200820.0
2011-11-10 19:30:00	SPY	ETF	124.17	124.25	123.95	124.1	105347.0
2011-11-10 20:00:00	SPY	ETF	124.1	124.12	124.1	124.12	1000.0
2011-11-10 04:00:00	QQQ	ETF	57.11	57.24	57.08	57.17	8020.0
2011-11-10 04:30:00	QQQ	ETF	57.26	57.52	57.26	57.46	4900.0
2011-11-10 05:00:00	QQQ	ETF	57.45	57.48	57.37	57.38	4900.0
2011-11-10 05:30:00	QQQ	ETF	57.28	57.28	57.27	57.27	3000.0
2011-11-10 06:00:00	QQQ	ETF	57.3	57.3	57.14	57.27	4900.0
2011-11-10 06:30:00	QQQ	ETF	57.25	57.4	57.25	57.4	3000.0
2011-11-10 07:00:00	QQQ	ETF	57.41	57.46	57.33	57.37	27348.0
2011-11-10 07:30:00	QQQ	ETF	57.42	57.62	57.42	57.51	95930.0
2011-11-10 08:00:00	QQQ	ETF	57.5	57.53	57.37	57.51	215626.0
2011-11-10 08:30:00	QQQ	ETF	57.52	57.6	57.4	57.51	171719.0
2011-11-10 09:00:00	QQQ	ETF	57.51	57.51	57.31	57.4	198347.0
2011-11-10 09:30:00	QQQ	ETF	57.39	57.42	56.76	56.79	6620869.0
2011-11-10 10:00:00	QQQ	ETF	56.79	56.97	56.47	56.57	7612756.0
2011-11-10 10:30:00	QQQ	ETF	56.56	56.57	56.23	56.45	7587908.0
2011-11-10 11:00:00	QQQ	ETF	56.45	56.81	56.425	56.68	6052877.0
2011-11-10 11:30:00	QQQ	ETF	56.68	56.98	56.62	56.83	5442933.0
2011-11-10 12:00:00	QQQ	ETF	56.83	56.86	56.66	56.66	2256959.0

> showing 50 of 9,324 rows — these rows as CSV

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