PREVIEW / etf_30min / 2011-03-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-25.parquet
  size:    281 KB
  rows:    9,303

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-03-25 04:00:00	SPY	ETF	131.3	131.47	131.3	131.4	1000.0
2011-03-25 04:30:00	SPY	ETF	131.32	131.32	131.25	131.25	300.0
2011-03-25 05:00:00	SPY	ETF	131.4	131.4	131.4	131.4	2000.0
2011-03-25 05:30:00	SPY	ETF	131.38	131.5	131.38	131.5	2300.0
2011-03-25 06:00:00	SPY	ETF	131.49	131.59	131.49	131.55	4800.0
2011-03-25 06:30:00	SPY	ETF	131.46	131.48	131.42	131.43	28750.0
2011-03-25 07:00:00	SPY	ETF	131.49	131.49	131.38	131.49	45170.0
2011-03-25 07:30:00	SPY	ETF	131.46	131.49	131.28	131.31	105109.0
2011-03-25 08:00:00	SPY	ETF	131.32	131.36	131.2	131.2	1522957.0
2011-03-25 08:30:00	SPY	ETF	131.2	131.32	131.14	131.2	889256.0
2011-03-25 09:00:00	SPY	ETF	131.19	131.27	131.12	131.23	897252.0
2011-03-25 09:30:00	SPY	ETF	131.24	131.3	130.94	131.1289	16849478.0
2011-03-25 10:00:00	SPY	ETF	131.12	131.34	131.02	131.29	8637640.0
2011-03-25 10:30:00	SPY	ETF	131.29	131.73	131.2862	131.69	13642208.0
2011-03-25 11:00:00	SPY	ETF	131.69	131.79	131.61	131.68	11230292.0
2011-03-25 11:30:00	SPY	ETF	131.68	131.825	131.64	131.75	7419968.0
2011-03-25 12:00:00	SPY	ETF	131.75	131.87	131.7	131.77	7074674.0
2011-03-25 12:30:00	SPY	ETF	131.775	131.79	131.6	131.61	7074440.0
2011-03-25 13:00:00	SPY	ETF	131.61	131.7	131.485	131.62	6727816.0
2011-03-25 13:30:00	SPY	ETF	131.6293	131.71	131.47	131.54	5328135.0
2011-03-25 14:00:00	SPY	ETF	131.535	131.65	131.39	131.42	6969320.0
2011-03-25 14:30:00	SPY	ETF	131.41	131.59	131.33	131.555	5555745.0
2011-03-25 15:00:00	SPY	ETF	131.56	131.62	131.4	131.41	7355974.0
2011-03-25 15:30:00	SPY	ETF	131.41	131.56	131.27	131.28	22326051.0
2011-03-25 16:00:00	SPY	ETF	131.28	131.611	130.8921	131.47	12823433.0
2011-03-25 16:30:00	SPY	ETF	131.47	131.52	130.8921	131.5	10063692.0
2011-03-25 17:00:00	SPY	ETF	131.49	131.53	131.42	131.45	149125.0
2011-03-25 17:30:00	SPY	ETF	131.47	131.5	131.44	131.5	58275.0
2011-03-25 18:00:00	SPY	ETF	131.46	131.53	131.29	131.5	104095.0
2011-03-25 18:30:00	SPY	ETF	131.46	131.47	131.45	131.45	3655.0
2011-03-25 19:00:00	SPY	ETF	131.5	131.53	131.47	131.47	3700.0
2011-03-25 19:30:00	SPY	ETF	131.52	131.58	131.51	131.51	25800.0
2011-03-25 04:00:00	QQQ	ETF	56.99	56.99	56.91	56.93	1598.0
2011-03-25 06:00:00	QQQ	ETF	56.96	56.96	56.96	56.96	813.0
2011-03-25 06:30:00	QQQ	ETF	56.96	56.98	56.94	56.94	3374.0
2011-03-25 07:00:00	QQQ	ETF	56.96	56.98	56.91	56.93	19260.0
2011-03-25 07:30:00	QQQ	ETF	56.95	56.95	56.89	56.9	20671.0
2011-03-25 08:00:00	QQQ	ETF	56.9	56.92	56.83	56.85	1020094.0
2011-03-25 08:30:00	QQQ	ETF	56.86	56.9	56.82	56.86	349780.0
2011-03-25 09:00:00	QQQ	ETF	56.86	56.9	56.79	56.89	656972.0
2011-03-25 09:30:00	QQQ	ETF	56.89	56.94	56.76	56.905	6675329.0
2011-03-25 10:00:00	QQQ	ETF	56.91	56.97	56.78	56.91	3067857.0
2011-03-25 10:30:00	QQQ	ETF	56.91	57.2	56.9	57.17	12162929.0
2011-03-25 11:00:00	QQQ	ETF	57.1784	57.22	57.09	57.1225	2857903.0
2011-03-25 11:30:00	QQQ	ETF	57.12	57.22	57.11	57.2	2744040.0
2011-03-25 12:00:00	QQQ	ETF	57.19	57.21	57.15	57.16	1703731.0
2011-03-25 12:30:00	QQQ	ETF	57.16	57.175	57.05	57.07	5603881.0
2011-03-25 13:00:00	QQQ	ETF	57.065	57.1084	57.01	57.1084	1875079.0
2011-03-25 13:30:00	QQQ	ETF	57.105	57.12	56.99	57.0	2783780.0
2011-03-25 14:00:00	QQQ	ETF	57.005	57.0186	56.85	56.87	4494420.0

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

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