PREVIEW / etf_30min / 2012-04-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-13.parquet
  size:    277 KB
  rows:    9,339

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
2012-04-13 04:00:00	SPY	ETF	138.68	138.68	138.43	138.43	2920.0
2012-04-13 04:30:00	SPY	ETF	138.39	138.51	138.36	138.4	2200.0
2012-04-13 05:00:00	SPY	ETF	138.43	138.43	138.22	138.37	48443.0
2012-04-13 05:30:00	SPY	ETF	138.43	138.51	138.4	138.46	5540.0
2012-04-13 06:00:00	SPY	ETF	138.41	138.65	138.41	138.55	24180.0
2012-04-13 06:30:00	SPY	ETF	138.6	138.92	138.6	138.9	230850.0
2012-04-13 07:00:00	SPY	ETF	138.9	139.01	138.7	138.9	468704.0
2012-04-13 07:30:00	SPY	ETF	138.88	138.9	138.43	138.43	246612.0
2012-04-13 08:00:00	SPY	ETF	138.43	138.94	138.31	138.36	762085.0
2012-04-13 08:30:00	SPY	ETF	138.4	138.57	138.22	138.54	1303607.0
2012-04-13 09:00:00	SPY	ETF	138.53	138.8708	138.33	138.47	821702.0
2012-04-13 09:30:00	SPY	ETF	138.47	138.48	137.87	137.92	21181495.0
2012-04-13 10:00:00	SPY	ETF	137.9201	138.08	137.51	137.68	16338818.0
2012-04-13 10:30:00	SPY	ETF	137.69	137.71	137.35	137.57	12710564.0
2012-04-13 11:00:00	SPY	ETF	137.57	137.69	137.41	137.58	9509177.0
2012-04-13 11:30:00	SPY	ETF	137.58	137.93	137.52	137.74	10266825.0
2012-04-13 12:00:00	SPY	ETF	137.73	137.77	137.57	137.62	4926829.0
2012-04-13 12:30:00	SPY	ETF	137.63	137.85	137.62	137.78	4948485.0
2012-04-13 13:00:00	SPY	ETF	137.775	138.8168	137.66	137.77	4184340.0
2012-04-13 13:30:00	SPY	ETF	137.77	137.97	137.67	137.6705	5390283.0
2012-04-13 14:00:00	SPY	ETF	137.68	137.84	137.55	137.66	9179839.0
2012-04-13 14:30:00	SPY	ETF	137.6604	137.81	137.63	137.71	4838966.0
2012-04-13 15:00:00	SPY	ETF	137.7	137.9	137.64	137.651	7078307.0
2012-04-13 15:30:00	SPY	ETF	137.65	137.74	137.01	137.13	28906497.0
2012-04-13 16:00:00	SPY	ETF	137.13	137.27	136.89	136.99	14378396.0
2012-04-13 16:30:00	SPY	ETF	136.98	138.8172	136.8668	136.96	5757026.0
2012-04-13 17:00:00	SPY	ETF	137.078	137.078	136.94	136.96	1774908.0
2012-04-13 17:30:00	SPY	ETF	136.96	137.14	136.96	137.12	171737.0
2012-04-13 18:00:00	SPY	ETF	137.12	137.23	137.09	137.16	155052.0
2012-04-13 18:30:00	SPY	ETF	137.14	137.16	137.09	137.1	12675.0
2012-04-13 19:00:00	SPY	ETF	137.1	137.11	137.0	137.01	19133.0
2012-04-13 19:30:00	SPY	ETF	137.01	137.05	136.96	136.96	10197.0
2012-04-13 05:30:00	QQQ	ETF	67.02	67.02	67.02	67.02	150.0
2012-04-13 06:00:00	QQQ	ETF	67.07	67.07	67.07	67.07	2000.0
2012-04-13 06:30:00	QQQ	ETF	67.09	67.12	67.09	67.11	12300.0
2012-04-13 07:00:00	QQQ	ETF	67.19	67.19	67.11	67.16	11600.0
2012-04-13 07:30:00	QQQ	ETF	67.18	67.18	66.98	66.98	116600.0
2012-04-13 08:00:00	QQQ	ETF	66.98	67.12	66.93	66.98	166135.0
2012-04-13 08:30:00	QQQ	ETF	66.96	67.03	66.92	67.02	71354.0
2012-04-13 09:00:00	QQQ	ETF	67.02	67.02	66.93	66.96	387282.0
2012-04-13 09:30:00	QQQ	ETF	66.96	66.99	66.68	66.7495	6720604.0
2012-04-13 10:00:00	QQQ	ETF	66.74	66.8393	66.4201	66.47	5558363.0
2012-04-13 10:30:00	QQQ	ETF	66.46	66.49	66.17	66.3814	4698406.0
2012-04-13 11:00:00	QQQ	ETF	66.38	66.44	66.235	66.4	4522111.0
2012-04-13 11:30:00	QQQ	ETF	66.39	66.6	66.33	66.45	5255025.0
2012-04-13 12:00:00	QQQ	ETF	66.45	66.49	66.4	66.42	1789850.0
2012-04-13 12:30:00	QQQ	ETF	66.42	66.49	66.379	66.469	2028902.0
2012-04-13 13:00:00	QQQ	ETF	66.46	66.52	66.4	66.451	1467204.0
2012-04-13 13:30:00	QQQ	ETF	66.45	66.59	66.42	66.43	2595800.0
2012-04-13 14:00:00	QQQ	ETF	66.43	66.51	66.36	66.409	3796188.0

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

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