PREVIEW / etf_30min / 2010-05-04

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-04.parquet
  size:    275 KB
  rows:    9,091

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
2010-05-04 04:00:00	SPY	ETF	120.25	120.25	120.13	120.13	860.0
2010-05-04 04:30:00	SPY	ETF	120.05	120.05	119.85	119.85	1200.0
2010-05-04 05:00:00	SPY	ETF	119.9	119.9	119.58	119.58	8700.0
2010-05-04 05:30:00	SPY	ETF	119.76	119.77	119.6	119.71	11366.0
2010-05-04 06:00:00	SPY	ETF	119.63	119.71	119.56	119.71	1900.0
2010-05-04 06:30:00	SPY	ETF	119.74	119.75	119.53	119.67	34896.0
2010-05-04 07:00:00	SPY	ETF	119.66	119.77	119.59	119.76	200800.0
2010-05-04 07:30:00	SPY	ETF	119.75	119.76	119.34	119.51	690847.0
2010-05-04 08:00:00	SPY	ETF	119.52	120.6	119.35	119.41	2073341.0
2010-05-04 08:30:00	SPY	ETF	119.4	120.3	119.12	119.16	1651831.0
2010-05-04 09:00:00	SPY	ETF	119.15	120.09	118.96	119.01	2529573.0
2010-05-04 09:30:00	SPY	ETF	119.01	119.03	118.19	118.59	44337932.0
2010-05-04 10:00:00	SPY	ETF	118.6	118.79	118.31	118.51	30021529.0
2010-05-04 10:30:00	SPY	ETF	118.52	118.53	117.54	117.56	37210723.0
2010-05-04 11:00:00	SPY	ETF	117.55	117.74	117.21	117.49	26030389.0
2010-05-04 11:30:00	SPY	ETF	117.49	117.86	117.44	117.77	15940522.0
2010-05-04 12:00:00	SPY	ETF	117.7705	117.78	117.04	117.2	19632519.0
2010-05-04 12:30:00	SPY	ETF	117.19	117.74	117.14	117.62	15249597.0
2010-05-04 13:00:00	SPY	ETF	117.63	117.73	117.37	117.47	12539592.0
2010-05-04 13:30:00	SPY	ETF	117.47	117.88	117.45	117.65	13270455.0
2010-05-04 14:00:00	SPY	ETF	117.64	117.71	117.31	117.32	14753764.0
2010-05-04 14:30:00	SPY	ETF	117.33	117.58	117.24	117.34	17104785.0
2010-05-04 15:00:00	SPY	ETF	117.3383	117.68	117.14	117.51	24827748.0
2010-05-04 15:30:00	SPY	ETF	117.51	117.71	116.92	117.55	48271223.0
2010-05-04 16:00:00	SPY	ETF	117.54	120.3862	117.27	117.71	18379672.0
2010-05-04 16:30:00	SPY	ETF	117.69	120.3862	117.52	117.6	3203825.0
2010-05-04 17:00:00	SPY	ETF	117.6	120.3861	117.41	117.41	8103001.0
2010-05-04 17:30:00	SPY	ETF	117.43	117.58	117.41	117.51	2330648.0
2010-05-04 18:00:00	SPY	ETF	117.48	117.58	117.38	117.41	191565.0
2010-05-04 18:30:00	SPY	ETF	117.41	117.46	117.36	117.4	40269.0
2010-05-04 19:00:00	SPY	ETF	117.4	117.41	117.35	117.38	10652.0
2010-05-04 19:30:00	SPY	ETF	117.35	117.58	117.32	117.55	62908.0
2010-05-04 04:30:00	QQQ	ETF	49.75	49.75	49.73	49.73	4350.0
2010-05-04 05:00:00	QQQ	ETF	49.65	49.65	49.64	49.64	1999.0
2010-05-04 05:30:00	QQQ	ETF	49.66	49.66	49.66	49.66	400.0
2010-05-04 06:00:00	QQQ	ETF	49.67	49.69	49.67	49.67	600.0
2010-05-04 06:30:00	QQQ	ETF	49.64	49.64	49.6	49.6	399.0
2010-05-04 07:00:00	QQQ	ETF	49.65	49.65	49.6	49.64	533406.0
2010-05-04 07:30:00	QQQ	ETF	49.61	49.63	49.49	49.57	104164.0
2010-05-04 08:00:00	QQQ	ETF	49.57	49.62	49.49	49.5	875555.0
2010-05-04 08:30:00	QQQ	ETF	49.5	49.6	49.35	49.36	997507.0
2010-05-04 09:00:00	QQQ	ETF	49.35	49.9	49.27	49.31	1867302.0
2010-05-04 09:30:00	QQQ	ETF	49.31	49.32	48.72	48.8787	18996372.0
2010-05-04 10:00:00	QQQ	ETF	48.88	48.91	48.62	48.6605	11346899.0
2010-05-04 10:30:00	QQQ	ETF	48.66	48.7	48.35	48.4099	11585334.0
2010-05-04 11:00:00	QQQ	ETF	48.41	48.43	48.17	48.3	10857066.0
2010-05-04 11:30:00	QQQ	ETF	48.3	48.48	48.28	48.46	5795589.0
2010-05-04 12:00:00	QQQ	ETF	48.46	48.46	48.11	48.14	7122094.0
2010-05-04 12:30:00	QQQ	ETF	48.13	48.38	48.08	48.3384	8715822.0
2010-05-04 13:00:00	QQQ	ETF	48.34	48.41	48.25	48.3	4222278.0

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

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