PREVIEW / etf_30min / 2011-05-12

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-12.parquet
  size:    283 KB
  rows:    9,426

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-12 04:00:00	SPY	ETF	134.01	134.02	133.58	133.66	12000.0
2011-05-12 04:30:00	SPY	ETF	133.73	133.73	133.56	133.65	1700.0
2011-05-12 05:00:00	SPY	ETF	133.55	133.75	133.55	133.64	20675.0
2011-05-12 05:30:00	SPY	ETF	133.74	133.74	133.58	133.58	21000.0
2011-05-12 06:00:00	SPY	ETF	133.58	133.75	133.46	133.59	12600.0
2011-05-12 06:30:00	SPY	ETF	133.56	133.65	133.4	133.63	98700.0
2011-05-12 07:00:00	SPY	ETF	133.7	133.8	133.53	133.56	327086.0
2011-05-12 07:30:00	SPY	ETF	133.57	133.87	133.57	133.82	268901.0
2011-05-12 08:00:00	SPY	ETF	133.41	133.82	133.41	133.74	1008275.0
2011-05-12 08:30:00	SPY	ETF	133.67	133.96	133.52	133.79	2116021.0
2011-05-12 09:00:00	SPY	ETF	133.78	134.15	133.75	134.1	3428658.0
2011-05-12 09:30:00	SPY	ETF	134.08	134.16	133.39	133.69	22718502.0
2011-05-12 10:00:00	SPY	ETF	133.68	134.1	133.42	133.96	19027294.0
2011-05-12 10:30:00	SPY	ETF	133.97	134.13	133.64	133.78	12236789.0
2011-05-12 11:00:00	SPY	ETF	133.78	134.33	133.66	134.27	13164500.0
2011-05-12 11:30:00	SPY	ETF	134.26	134.55	134.24	134.26	12050885.0
2011-05-12 12:00:00	SPY	ETF	134.26	134.41	134.15	134.405	5318857.0
2011-05-12 12:30:00	SPY	ETF	134.4	134.65	134.28	134.6	7850152.0
2011-05-12 13:00:00	SPY	ETF	134.6	135.2	134.595	135.04	14301550.0
2011-05-12 13:30:00	SPY	ETF	135.04	135.22	134.97	135.11	7333211.0
2011-05-12 14:00:00	SPY	ETF	135.12	135.36	134.95	135.03	9473889.0
2011-05-12 14:30:00	SPY	ETF	135.025	135.11	134.85	134.875	6989902.0
2011-05-12 15:00:00	SPY	ETF	134.87	135.14	134.79	135.03	9364585.0
2011-05-12 15:30:00	SPY	ETF	135.02	135.24	134.9	135.11	16873940.0
2011-05-12 16:00:00	SPY	ETF	135.09	135.28	134.4199	135.22	5937954.0
2011-05-12 16:30:00	SPY	ETF	135.21	135.23	135.11	135.17	379350.0
2011-05-12 17:00:00	SPY	ETF	135.17	135.27	135.17	135.22	129662.0
2011-05-12 17:30:00	SPY	ETF	135.22	135.23	135.15	135.2	66700.0
2011-05-12 18:00:00	SPY	ETF	135.21	135.25	135.1	135.24	135294.0
2011-05-12 18:30:00	SPY	ETF	135.24	135.24	135.15	135.16	16722.0
2011-05-12 19:00:00	SPY	ETF	135.19	135.2	135.18	135.18	4872.0
2011-05-12 19:30:00	SPY	ETF	135.22	135.25	135.22	135.25	16851.0
2011-05-12 04:30:00	QQQ	ETF	58.43	58.43	58.36	58.36	1000.0
2011-05-12 05:00:00	QQQ	ETF	58.34	58.5	58.34	58.5	50100.0
2011-05-12 06:00:00	QQQ	ETF	58.36	58.36	58.36	58.36	1000.0
2011-05-12 06:30:00	QQQ	ETF	58.44	58.46	58.44	58.46	25000.0
2011-05-12 07:00:00	QQQ	ETF	58.44	58.48	58.39	58.39	45900.0
2011-05-12 07:30:00	QQQ	ETF	58.42	58.49	58.39	58.49	15300.0
2011-05-12 08:00:00	QQQ	ETF	58.48	58.48	58.42	58.43	193152.0
2011-05-12 08:30:00	QQQ	ETF	58.43	58.52	58.36	58.48	330716.0
2011-05-12 09:00:00	QQQ	ETF	58.47	58.65	58.36	58.56	3015791.0
2011-05-12 09:30:00	QQQ	ETF	58.56	58.605	58.24	58.475	7842630.0
2011-05-12 10:00:00	QQQ	ETF	58.475	58.76	58.37	58.66	7513817.0
2011-05-12 10:30:00	QQQ	ETF	58.66	58.73	58.47	58.53	5445057.0
2011-05-12 11:00:00	QQQ	ETF	58.53	58.78	58.48	58.75	2545493.0
2011-05-12 11:30:00	QQQ	ETF	58.75	58.87	58.73	58.73	5001653.0
2011-05-12 12:00:00	QQQ	ETF	58.73	58.825	58.71	58.82	1588073.0
2011-05-12 12:30:00	QQQ	ETF	58.82	58.89	58.75	58.87	2296079.0
2011-05-12 13:00:00	QQQ	ETF	58.8601	59.09	58.8601	59.02	3173118.0
2011-05-12 13:30:00	QQQ	ETF	59.0299	59.09	58.99	59.05	1696454.0

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

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