PREVIEW / etf_30min / 2011-10-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-25.parquet
  size:    292 KB
  rows:    9,677

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-10-25 04:00:00	SPY	ETF	125.38	125.38	125.16	125.16	550.0
2011-10-25 04:30:00	SPY	ETF	125.24	125.34	125.24	125.34	590.0
2011-10-25 05:00:00	SPY	ETF	125.39	125.49	125.39	125.49	300.0
2011-10-25 05:30:00	SPY	ETF	125.44	125.44	125.43	125.43	200.0
2011-10-25 06:00:00	SPY	ETF	125.36	125.53	125.24	125.53	17400.0
2011-10-25 06:30:00	SPY	ETF	125.5	125.95	125.5	125.85	156820.0
2011-10-25 07:00:00	SPY	ETF	125.76	125.99	125.76	125.8	154764.0
2011-10-25 07:30:00	SPY	ETF	125.79	125.82	125.62	125.72	404168.0
2011-10-25 08:00:00	SPY	ETF	125.71	125.79	125.0	125.18	2821698.0
2011-10-25 08:30:00	SPY	ETF	125.19	125.27	124.77	124.87	1948059.0
2011-10-25 09:00:00	SPY	ETF	124.87	125.11	124.58	124.88	4009520.0
2011-10-25 09:30:00	SPY	ETF	124.89	124.95	123.33	124.01	57350980.0
2011-10-25 10:00:00	SPY	ETF	124.0	124.53	123.62	124.43	28580181.0
2011-10-25 10:30:00	SPY	ETF	124.42	124.72	124.1	124.17	16860258.0
2011-10-25 11:00:00	SPY	ETF	124.17	124.32	123.7	123.91	16686646.0
2011-10-25 11:30:00	SPY	ETF	123.91	124.18	123.78	124.04	9255289.0
2011-10-25 12:00:00	SPY	ETF	124.05	124.64	123.915	124.56	11218787.0
2011-10-25 12:30:00	SPY	ETF	124.57	124.62	124.07	124.1	7747717.0
2011-10-25 13:00:00	SPY	ETF	124.1	124.5	124.09	124.25	8989687.0
2011-10-25 13:30:00	SPY	ETF	124.25	124.32	123.97	124.2	9761698.0
2011-10-25 14:00:00	SPY	ETF	124.21	124.21	123.66	123.76	13087115.0
2011-10-25 14:30:00	SPY	ETF	123.75	124.03	123.58	123.99	10794719.0
2011-10-25 15:00:00	SPY	ETF	124.0	124.22	123.4	123.53	18063998.0
2011-10-25 15:30:00	SPY	ETF	123.53	123.76	122.78	123.06	32756007.0
2011-10-25 16:00:00	SPY	ETF	123.06	124.7	122.82	123.11	8722019.0
2011-10-25 16:30:00	SPY	ETF	123.08	123.14	122.93	123.02	1879663.0
2011-10-25 17:00:00	SPY	ETF	123.04	123.12	123.0	123.12	414229.0
2011-10-25 17:30:00	SPY	ETF	123.1	123.17	123.06	123.06	97061.0
2011-10-25 18:00:00	SPY	ETF	123.09	125.5299	123.02	123.14	4504900.0
2011-10-25 18:30:00	SPY	ETF	123.15	123.18	122.98	123.0	34712.0
2011-10-25 19:00:00	SPY	ETF	122.98	123.05	122.86	123.01	74042.0
2011-10-25 19:30:00	SPY	ETF	123.01	123.07	122.97	122.99	57540.0
2011-10-25 06:00:00	QQQ	ETF	58.5	58.5	58.5	58.5	2000.0
2011-10-25 06:30:00	QQQ	ETF	58.62	58.68	58.6	58.6	40588.0
2011-10-25 07:00:00	QQQ	ETF	58.58	58.65	58.57	58.6	27000.0
2011-10-25 07:30:00	QQQ	ETF	58.6	58.61	58.54	58.57	134424.0
2011-10-25 08:00:00	QQQ	ETF	58.58	58.59	58.38	58.38	304122.0
2011-10-25 08:30:00	QQQ	ETF	58.39	58.42	58.25	58.28	220611.0
2011-10-25 09:00:00	QQQ	ETF	58.28	58.36	58.17	58.26	972711.0
2011-10-25 09:30:00	QQQ	ETF	58.27	58.32	57.77	58.06	11928667.0
2011-10-25 10:00:00	QQQ	ETF	57.98	58.16	57.8	58.07	6136405.0
2011-10-25 10:30:00	QQQ	ETF	58.0687	58.22	57.97	57.99	3332174.0
2011-10-25 11:00:00	QQQ	ETF	57.99	58.06	57.73	57.81	3838036.0
2011-10-25 11:30:00	QQQ	ETF	57.81	57.91	57.7	57.76	2883028.0
2011-10-25 12:00:00	QQQ	ETF	57.76	58.03	57.71	57.99	2719632.0
2011-10-25 12:30:00	QQQ	ETF	57.99	58.02	57.7816	57.8	2627399.0
2011-10-25 13:00:00	QQQ	ETF	57.8	57.97	57.8	57.86	1718655.0
2011-10-25 13:30:00	QQQ	ETF	57.85	57.85	57.71	57.7735	2097728.0
2011-10-25 14:00:00	QQQ	ETF	57.77	57.77	57.46	57.54	4401810.0
2011-10-25 14:30:00	QQQ	ETF	57.54	57.68	57.44	57.67	2971150.0

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

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