PREVIEW / etf_30min / 2011-03-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-23.parquet
  size:    279 KB
  rows:    9,105

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-23 04:00:00	SPY	ETF	128.95	129.14	128.91	129.14	3040.0
2011-03-23 04:30:00	SPY	ETF	128.99	128.99	128.99	128.99	100.0
2011-03-23 05:00:00	SPY	ETF	128.93	129.01	128.93	129.01	1100.0
2011-03-23 05:30:00	SPY	ETF	129.3	129.71	129.3	129.71	1100.0
2011-03-23 06:00:00	SPY	ETF	129.64	129.7	129.61	129.61	14078.0
2011-03-23 06:30:00	SPY	ETF	129.65	129.67	129.58	129.62	42300.0
2011-03-23 07:00:00	SPY	ETF	129.6	129.66	129.3	129.32	873317.0
2011-03-23 07:30:00	SPY	ETF	129.34	129.36	128.95	129.03	337901.0
2011-03-23 08:00:00	SPY	ETF	129.03	129.415	128.89	129.1	1550341.0
2011-03-23 08:30:00	SPY	ETF	129.1	129.14	128.85	128.94	595565.0
2011-03-23 09:00:00	SPY	ETF	128.93	129.11	128.89	128.91	1091563.0
2011-03-23 09:30:00	SPY	ETF	128.93	129.02	128.56	128.88	15299506.0
2011-03-23 10:00:00	SPY	ETF	128.86	128.87	128.32	128.62	15787594.0
2011-03-23 10:30:00	SPY	ETF	128.62	128.72	128.36	128.535	8174124.0
2011-03-23 11:00:00	SPY	ETF	128.53	128.88	128.53	128.79	10109870.0
2011-03-23 11:30:00	SPY	ETF	128.79	129.3045	128.68	128.81	8402053.0
2011-03-23 12:00:00	SPY	ETF	128.81	129.23	128.72	129.19	7494074.0
2011-03-23 12:30:00	SPY	ETF	129.19	129.3	129.12	129.19	7579831.0
2011-03-23 13:00:00	SPY	ETF	129.18	129.3	129.08	129.221	6843871.0
2011-03-23 13:30:00	SPY	ETF	129.22	129.57	129.22	129.445	11813212.0
2011-03-23 14:00:00	SPY	ETF	129.45	129.47	129.33	129.44	5720663.0
2011-03-23 14:30:00	SPY	ETF	129.43	129.87	129.38	129.77	9484767.0
2011-03-23 15:00:00	SPY	ETF	129.78	130.0	129.68	129.94	10470963.0
2011-03-23 15:30:00	SPY	ETF	129.94	129.94	129.65	129.66	17459612.0
2011-03-23 16:00:00	SPY	ETF	129.66	129.8104	128.4175	129.62	7053687.0
2011-03-23 16:30:00	SPY	ETF	129.62	129.62	129.53	129.57	399487.0
2011-03-23 17:00:00	SPY	ETF	129.56	129.57	129.39	129.41	158539.0
2011-03-23 17:30:00	SPY	ETF	129.41	129.48	129.4	129.46	24659.0
2011-03-23 18:00:00	SPY	ETF	129.42	129.68	129.38	129.61	330391.0
2011-03-23 18:30:00	SPY	ETF	129.61	129.62	129.56	129.6	32450.0
2011-03-23 19:00:00	SPY	ETF	129.59	129.64	129.57	129.62	22712.0
2011-03-23 19:30:00	SPY	ETF	129.63	129.73	129.63	129.66	71837.0
2011-03-23 06:00:00	QQQ	ETF	55.5	55.5	55.5	55.5	100.0
2011-03-23 06:30:00	QQQ	ETF	55.45	55.48	55.45	55.48	200.0
2011-03-23 07:00:00	QQQ	ETF	55.48	55.51	55.34	55.38	170200.0
2011-03-23 07:30:00	QQQ	ETF	55.37	55.38	55.19	55.23	168061.0
2011-03-23 08:00:00	QQQ	ETF	55.21	55.4	55.21	55.25	625025.0
2011-03-23 08:30:00	QQQ	ETF	55.29	55.3	55.2	55.21	613713.0
2011-03-23 09:00:00	QQQ	ETF	55.2	55.28	55.18	55.2	244386.0
2011-03-23 09:30:00	QQQ	ETF	55.19	55.29	55.0	55.15	9069807.0
2011-03-23 10:00:00	QQQ	ETF	55.11	55.16	54.82	55.03	10423202.0
2011-03-23 10:30:00	QQQ	ETF	55.021	55.08	54.91	55.0	3199160.0
2011-03-23 11:00:00	QQQ	ETF	55.01	55.27	55.01	55.21	2736142.0
2011-03-23 11:30:00	QQQ	ETF	55.22	55.38	55.22	55.2722	2563252.0
2011-03-23 12:00:00	QQQ	ETF	55.28	55.55	55.25	55.52	2628476.0
2011-03-23 12:30:00	QQQ	ETF	55.52	55.57	55.42	55.45	1914376.0
2011-03-23 13:00:00	QQQ	ETF	55.45	55.51	55.39	55.4675	1457657.0
2011-03-23 13:30:00	QQQ	ETF	55.47	55.59	55.47	55.5299	2832962.0
2011-03-23 14:00:00	QQQ	ETF	55.53	55.55	55.45	55.54	2656854.0
2011-03-23 14:30:00	QQQ	ETF	55.5312	55.82	55.51	55.7601	3985611.0

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

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