PREVIEW / etf_30min / 2013-01-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-25.parquet
  size:    317 KB
  rows:    10,712

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-01-25 04:00:00	SPY	ETF	149.66	149.85	149.66	149.84	3450.0
2013-01-25 04:30:00	SPY	ETF	149.86	149.87	149.84	149.87	10688.0
2013-01-25 05:00:00	SPY	ETF	149.87	149.97	149.87	149.91	30425.0
2013-01-25 05:30:00	SPY	ETF	149.91	149.94	149.9	149.91	28300.0
2013-01-25 06:00:00	SPY	ETF	149.92	149.99	149.81	149.84	56254.0
2013-01-25 06:30:00	SPY	ETF	149.84	149.94	149.84	149.91	18040.0
2013-01-25 07:00:00	SPY	ETF	149.89	150.04	149.87	149.99	223509.0
2013-01-25 07:30:00	SPY	ETF	150.01	150.12	149.98	150.0	439938.0
2013-01-25 08:00:00	SPY	ETF	149.98	150.07	149.9	150.05	479929.0
2013-01-25 08:30:00	SPY	ETF	150.05	150.06	149.88	149.91	425998.0
2013-01-25 09:00:00	SPY	ETF	149.92	149.95	149.84	149.89	750772.0
2013-01-25 09:30:00	SPY	ETF	149.88	150.11	149.75	150.03	13313532.0
2013-01-25 10:00:00	SPY	ETF	150.03	150.032	149.5	149.51	11055893.0
2013-01-25 10:30:00	SPY	ETF	149.5199	149.67	149.46	149.6305	7338065.0
2013-01-25 11:00:00	SPY	ETF	149.64	149.82	149.6	149.6901	5863312.0
2013-01-25 11:30:00	SPY	ETF	149.69	150.005	149.63	149.645	3940517.0
2013-01-25 12:00:00	SPY	ETF	149.645	150.05	149.638	149.87	5578671.0
2013-01-25 12:30:00	SPY	ETF	149.875	149.97	149.85	149.8602	3488863.0
2013-01-25 13:00:00	SPY	ETF	149.87	150.03	149.85	149.968	4294309.0
2013-01-25 13:30:00	SPY	ETF	149.9675	150.16	149.94	150.075	6310857.0
2013-01-25 14:00:00	SPY	ETF	150.08	150.22	150.06	150.128	3597672.0
2013-01-25 14:30:00	SPY	ETF	150.13	150.24	150.03	150.05	8507498.0
2013-01-25 15:00:00	SPY	ETF	150.05	150.12	149.94	150.1	5708568.0
2013-01-25 15:30:00	SPY	ETF	150.095	150.21	149.79	150.2	27614636.0
2013-01-25 16:00:00	SPY	ETF	150.2	150.29	149.3726	149.94	24082783.0
2013-01-25 16:30:00	SPY	ETF	149.95	149.99	149.8999	149.97	11047177.0
2013-01-25 17:00:00	SPY	ETF	149.96	150.0	149.96	150.0	1088509.0
2013-01-25 17:30:00	SPY	ETF	150.0	150.25	149.99	150.0	9905.0
2013-01-25 18:00:00	SPY	ETF	150.0	150.04	150.0	150.03	15405.0
2013-01-25 18:30:00	SPY	ETF	150.03	150.09	150.03	150.04	43689.0
2013-01-25 19:00:00	SPY	ETF	150.03	150.1	150.03	150.03	6964.0
2013-01-25 19:30:00	SPY	ETF	150.06	150.07	150.0	150.03	7766.0
2013-01-25 04:00:00	QQQ	ETF	66.86	66.86	66.86	66.86	500.0
2013-01-25 04:30:00	QQQ	ETF	66.88	66.88	66.88	66.88	4000.0
2013-01-25 05:00:00	QQQ	ETF	66.92	66.93	66.92	66.93	4378.0
2013-01-25 05:30:00	QQQ	ETF	66.91	66.91	66.91	66.91	100.0
2013-01-25 06:00:00	QQQ	ETF	66.91	66.91	66.91	66.91	200.0
2013-01-25 07:00:00	QQQ	ETF	66.95	66.98	66.95	66.96	14951.0
2013-01-25 07:30:00	QQQ	ETF	66.97	66.99	66.95	66.96	9200.0
2013-01-25 08:00:00	QQQ	ETF	66.99	66.99	66.91	66.96	65358.0
2013-01-25 08:30:00	QQQ	ETF	66.98	66.98	66.91	66.91	15600.0
2013-01-25 09:00:00	QQQ	ETF	66.89	66.91	66.84	66.87	46447.0
2013-01-25 09:30:00	QQQ	ETF	66.89	67.19	66.74	67.14	3990170.0
2013-01-25 10:00:00	QQQ	ETF	67.13	67.14	66.79	66.8	4365891.0
2013-01-25 10:30:00	QQQ	ETF	66.8	66.86	66.75	66.8185	2027576.0
2013-01-25 11:00:00	QQQ	ETF	66.8199	66.9699	66.81	66.89	3830086.0
2013-01-25 11:30:00	QQQ	ETF	66.9	66.92	66.7432	66.75	2081092.0
2013-01-25 12:00:00	QQQ	ETF	66.76	66.99	66.75	66.8215	1632618.0
2013-01-25 12:30:00	QQQ	ETF	66.83	66.93	66.77	66.8355	2260874.0
2013-01-25 13:00:00	QQQ	ETF	66.84	66.96	66.82	66.92	1116179.0

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

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