PREVIEW / etf_30min / 2011-01-27

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-27.parquet
  size:    273 KB
  rows:    9,143

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-01-27 04:00:00	SPY	ETF	129.64	129.64	129.42	129.52	6460.0
2011-01-27 04:30:00	SPY	ETF	129.52	129.67	129.52	129.65	2680.0
2011-01-27 05:00:00	SPY	ETF	129.69	129.69	129.67	129.67	200.0
2011-01-27 05:30:00	SPY	ETF	129.69	129.85	129.69	129.85	5180.0
2011-01-27 06:00:00	SPY	ETF	129.75	129.75	129.72	129.72	4280.0
2011-01-27 06:30:00	SPY	ETF	129.67	129.7	129.47	129.67	8100.0
2011-01-27 07:00:00	SPY	ETF	129.69	129.77	129.59	129.71	82500.0
2011-01-27 07:30:00	SPY	ETF	129.7	130.01	129.7	129.87	249399.0
2011-01-27 08:00:00	SPY	ETF	129.7	130.0	129.7	129.9	739287.0
2011-01-27 08:30:00	SPY	ETF	129.89	129.89	129.43	129.51	2769799.0
2011-01-27 09:00:00	SPY	ETF	129.5	129.75	129.47	129.7	5339044.0
2011-01-27 09:30:00	SPY	ETF	129.7	130.02	129.58	129.97	15214145.0
2011-01-27 10:00:00	SPY	ETF	129.97	130.17	129.77	129.98	11684068.0
2011-01-27 10:30:00	SPY	ETF	129.9838	130.1	129.87	129.935	7249111.0
2011-01-27 11:00:00	SPY	ETF	129.94	129.96	129.47	129.54	11725723.0
2011-01-27 11:30:00	SPY	ETF	129.54	129.76	129.47	129.7	7883602.0
2011-01-27 12:00:00	SPY	ETF	129.71	129.86	129.68	129.81	4740491.0
2011-01-27 12:30:00	SPY	ETF	129.81	129.97	129.75	129.95	5001212.0
2011-01-27 13:00:00	SPY	ETF	129.95	130.02	129.86	129.935	2720260.0
2011-01-27 13:30:00	SPY	ETF	129.94	130.01	129.86	129.9562	4671895.0
2011-01-27 14:00:00	SPY	ETF	129.96	129.99	129.79	129.7901	4073368.0
2011-01-27 14:30:00	SPY	ETF	129.8	130.05	129.79	129.99	6576046.0
2011-01-27 15:00:00	SPY	ETF	130.0	130.05	129.88	130.048	5192189.0
2011-01-27 15:30:00	SPY	ETF	130.04	130.21	129.9	130.02	19264016.0
2011-01-27 16:00:00	SPY	ETF	130.02	130.06	129.56	129.96	7429739.0
2011-01-27 16:30:00	SPY	ETF	129.96	129.96	129.84	129.93	541249.0
2011-01-27 17:00:00	SPY	ETF	129.93	129.93	129.85	129.85	98391.0
2011-01-27 17:30:00	SPY	ETF	129.89	129.95	129.86	129.89	72500.0
2011-01-27 18:00:00	SPY	ETF	129.88	130.03	129.84	129.86	27085.0
2011-01-27 18:30:00	SPY	ETF	129.86	129.89	129.85	129.85	25700.0
2011-01-27 19:00:00	SPY	ETF	129.86	129.86	129.82	129.82	36518.0
2011-01-27 19:30:00	SPY	ETF	129.83	129.86	129.8	129.84	21399.0
2011-01-27 04:30:00	QQQ	ETF	56.93	56.93	56.93	56.93	300.0
2011-01-27 05:30:00	QQQ	ETF	57.0	57.02	57.0	57.02	200.0
2011-01-27 06:30:00	QQQ	ETF	57.02	57.02	56.99	56.99	282.0
2011-01-27 07:00:00	QQQ	ETF	56.99	57.04	56.97	56.97	18997.0
2011-01-27 07:30:00	QQQ	ETF	57.03	57.08	57.02	57.02	15778.0
2011-01-27 08:00:00	QQQ	ETF	57.12	57.12	57.03	57.09	117493.0
2011-01-27 08:30:00	QQQ	ETF	57.08	57.08	56.89	56.92	247780.0
2011-01-27 09:00:00	QQQ	ETF	56.92	57.04	56.91	57.0	191431.0
2011-01-27 09:30:00	QQQ	ETF	57.01	57.18	56.96	57.15	5621066.0
2011-01-27 10:00:00	QQQ	ETF	57.15	57.22	57.0	57.14	4096539.0
2011-01-27 10:30:00	QQQ	ETF	57.14	57.17	57.04	57.08	2416910.0
2011-01-27 11:00:00	QQQ	ETF	57.08	57.1	56.92	56.99	3847696.0
2011-01-27 11:30:00	QQQ	ETF	56.99	57.11	56.9301	57.0695	3635021.0
2011-01-27 12:00:00	QQQ	ETF	57.07	57.14	57.05	57.11	2679062.0
2011-01-27 12:30:00	QQQ	ETF	57.1	57.27	57.0901	57.25	3788968.0
2011-01-27 13:00:00	QQQ	ETF	57.26	57.27	57.2	57.215	1172598.0
2011-01-27 13:30:00	QQQ	ETF	57.22	57.24	57.17	57.24	930480.0
2011-01-27 14:00:00	QQQ	ETF	57.23	57.24	57.15	57.16	1080799.0

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

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