PREVIEW / etf_30min / 2011-05-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-06.parquet
  size:    288 KB
  rows:    9,394

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-05-06 04:00:00	SPY	ETF	133.97	134.06	133.9	134.06	2500.0
2011-05-06 04:30:00	SPY	ETF	134.08	134.23	134.08	134.2	900.0
2011-05-06 05:00:00	SPY	ETF	134.32	134.55	134.32	134.54	5100.0
2011-05-06 05:30:00	SPY	ETF	134.54	134.56	134.39	134.39	2300.0
2011-05-06 06:00:00	SPY	ETF	134.46	134.52	134.46	134.51	750.0
2011-05-06 06:30:00	SPY	ETF	134.44	134.46	134.3	134.35	19400.0
2011-05-06 07:00:00	SPY	ETF	134.35	134.37	134.25	134.25	92892.0
2011-05-06 07:30:00	SPY	ETF	134.27	134.27	134.07	134.21	372884.0
2011-05-06 08:00:00	SPY	ETF	134.18	134.67	134.11	134.34	875746.0
2011-05-06 08:30:00	SPY	ETF	134.39	135.26	134.39	135.12	8889956.0
2011-05-06 09:00:00	SPY	ETF	135.13	135.44	134.92	134.94	3627157.0
2011-05-06 09:30:00	SPY	ETF	134.94	135.43	134.83	135.01	24427047.0
2011-05-06 10:00:00	SPY	ETF	135.01	135.28	134.8	135.16	12420736.0
2011-05-06 10:30:00	SPY	ETF	135.17	135.3	135.08	135.11	8785627.0
2011-05-06 11:00:00	SPY	ETF	135.11	135.63	135.1	135.48	12957833.0
2011-05-06 11:30:00	SPY	ETF	135.48	135.54	135.15	135.29	11313381.0
2011-05-06 12:00:00	SPY	ETF	135.3	135.42	134.71	134.815	23153523.0
2011-05-06 12:30:00	SPY	ETF	134.82	135.01	134.38	134.71	14769799.0
2011-05-06 13:00:00	SPY	ETF	134.72	134.87	134.05	134.34	18704649.0
2011-05-06 13:30:00	SPY	ETF	134.34	134.52	134.16	134.27	7887383.0
2011-05-06 14:00:00	SPY	ETF	134.26	134.6	133.22	134.13	10916913.0
2011-05-06 14:30:00	SPY	ETF	134.13	134.13	133.68	133.9701	14516298.0
2011-05-06 15:00:00	SPY	ETF	133.98	134.29	133.94	134.03	9667126.0
2011-05-06 15:30:00	SPY	ETF	134.04	134.45	134.02	134.17	24507235.0
2011-05-06 16:00:00	SPY	ETF	134.17	134.4457	133.92	134.0	14565724.0
2011-05-06 16:30:00	SPY	ETF	134.0	134.6869	133.95	133.97	197593.0
2011-05-06 17:00:00	SPY	ETF	133.99	134.0	133.93	134.0	70500.0
2011-05-06 17:30:00	SPY	ETF	134.0	134.01	133.97	134.0	17352.0
2011-05-06 18:00:00	SPY	ETF	134.0	134.2	133.98	134.0	107040.0
2011-05-06 18:30:00	SPY	ETF	134.0	134.03	133.97	134.02	16630.0
2011-05-06 19:00:00	SPY	ETF	134.03	134.05	134.02	134.05	9670.0
2011-05-06 19:30:00	SPY	ETF	134.02	134.06	133.98	134.06	15158.0
2011-05-06 04:00:00	QQQ	ETF	58.39	58.42	58.38	58.42	450.0
2011-05-06 06:30:00	QQQ	ETF	58.69	58.7	58.67	58.7	1300.0
2011-05-06 07:00:00	QQQ	ETF	58.63	58.64	58.58	58.58	42900.0
2011-05-06 07:30:00	QQQ	ETF	58.58	58.58	58.52	58.54	29963.0
2011-05-06 08:00:00	QQQ	ETF	58.52	58.6	58.52	58.57	147437.0
2011-05-06 08:30:00	QQQ	ETF	58.65	59.09	58.59	59.04	2642936.0
2011-05-06 09:00:00	QQQ	ETF	59.05	59.14	58.87	58.87	838043.0
2011-05-06 09:30:00	QQQ	ETF	58.86	59.03	58.67	58.818	10317702.0
2011-05-06 10:00:00	QQQ	ETF	58.8162	58.9006	58.71	58.85	5634438.0
2011-05-06 10:30:00	QQQ	ETF	58.85	58.9601	58.8	58.94	2769242.0
2011-05-06 11:00:00	QQQ	ETF	58.95	59.15	58.94	59.11	3289726.0
2011-05-06 11:30:00	QQQ	ETF	59.12	59.2	59.06	59.131	4369114.0
2011-05-06 12:00:00	QQQ	ETF	59.13	59.16	58.92	58.96	5794269.0
2011-05-06 12:30:00	QQQ	ETF	58.95	59.035	58.76	58.8601	3220803.0
2011-05-06 13:00:00	QQQ	ETF	58.87	58.91	58.57	58.64	5896381.0
2011-05-06 13:30:00	QQQ	ETF	58.65	58.71	58.56	58.6	2936509.0
2011-05-06 14:00:00	QQQ	ETF	58.6	58.75	58.51	58.55	2666968.0
2011-05-06 14:30:00	QQQ	ETF	58.55	58.56	58.31	58.43	4788766.0

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

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