PREVIEW / etf_30min / 2010-12-31

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-31.parquet
  size:    258 KB
  rows:    8,714

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-12-31 04:00:00	SPY	ETF	125.88	125.88	125.88	125.88	300.0
2010-12-31 04:30:00	SPY	ETF	125.8	125.8	125.8	125.8	200.0
2010-12-31 06:00:00	SPY	ETF	125.74	125.75	125.74	125.74	10800.0
2010-12-31 06:30:00	SPY	ETF	125.7	125.7	125.7	125.7	200.0
2010-12-31 07:00:00	SPY	ETF	125.67	125.67	125.6	125.64	28127.0
2010-12-31 07:30:00	SPY	ETF	125.64	125.64	125.54	125.54	24736.0
2010-12-31 08:00:00	SPY	ETF	125.54	125.57	125.38	125.48	384796.0
2010-12-31 08:30:00	SPY	ETF	125.49	125.52	125.47	125.5	261660.0
2010-12-31 09:00:00	SPY	ETF	125.51	125.53	125.47	125.51	368962.0
2010-12-31 09:30:00	SPY	ETF	125.53	125.63	125.33	125.44	9340449.0
2010-12-31 10:00:00	SPY	ETF	125.43	125.57	125.36	125.565	4182086.0
2010-12-31 10:30:00	SPY	ETF	125.5602	125.72	125.53	125.7	5330482.0
2010-12-31 11:00:00	SPY	ETF	125.71	125.78	125.65	125.76	2846267.0
2010-12-31 11:30:00	SPY	ETF	125.765	125.78	125.73	125.75	2045571.0
2010-12-31 12:00:00	SPY	ETF	125.75	125.86	125.72	125.86	3116484.0
2010-12-31 12:30:00	SPY	ETF	125.86	125.87	125.64	125.72	4957204.0
2010-12-31 13:00:00	SPY	ETF	125.73	125.82	125.71	125.81	2224441.0
2010-12-31 13:30:00	SPY	ETF	125.8162	125.85	125.71	125.77	4455286.0
2010-12-31 14:00:00	SPY	ETF	125.77	125.8	125.73	125.75	2590148.0
2010-12-31 14:30:00	SPY	ETF	125.76	125.87	125.75	125.8	3219990.0
2010-12-31 15:00:00	SPY	ETF	125.8099	125.84	125.76	125.83	5983489.0
2010-12-31 15:30:00	SPY	ETF	125.825	125.86	125.52	125.8	23753567.0
2010-12-31 16:00:00	SPY	ETF	125.81	126.13	125.396	126.04	11373520.0
2010-12-31 16:30:00	SPY	ETF	126.05	126.05	125.98	126.0	2899022.0
2010-12-31 17:00:00	SPY	ETF	126.0	126.0571	125.99	125.99	281376.0
2010-12-31 17:30:00	SPY	ETF	125.99	126.04	125.99	126.0	11800.0
2010-12-31 18:00:00	SPY	ETF	126.03	126.03	125.99	125.99	26274.0
2010-12-31 18:30:00	SPY	ETF	125.99	126.04	125.98	126.0	23642.0
2010-12-31 19:00:00	SPY	ETF	126.0	126.04	126.0	126.0	6684.0
2010-12-31 19:30:00	SPY	ETF	126.0	126.05	125.99	126.03	6810.0
2010-12-31 04:00:00	QQQ	ETF	54.65	54.65	54.65	54.65	200.0
2010-12-31 05:30:00	QQQ	ETF	54.62	54.62	54.62	54.62	200.0
2010-12-31 06:00:00	QQQ	ETF	54.62	54.62	54.62	54.62	250.0
2010-12-31 06:30:00	QQQ	ETF	54.62	54.62	54.62	54.62	100.0
2010-12-31 07:00:00	QQQ	ETF	54.59	54.59	54.59	54.59	320.0
2010-12-31 07:30:00	QQQ	ETF	54.6	54.6	54.59	54.59	200.0
2010-12-31 08:00:00	QQQ	ETF	54.58	54.6	54.55	54.57	17371.0
2010-12-31 08:30:00	QQQ	ETF	54.59	54.62	54.58	54.59	7526.0
2010-12-31 09:00:00	QQQ	ETF	54.59	54.61	54.58	54.6	277600.0
2010-12-31 09:30:00	QQQ	ETF	54.6	54.62	54.21	54.33	11592910.0
2010-12-31 10:00:00	QQQ	ETF	54.33	54.35	54.24	54.33	1973548.0
2010-12-31 10:30:00	QQQ	ETF	54.335	54.36	54.29	54.3465	1728208.0
2010-12-31 11:00:00	QQQ	ETF	54.345	54.38	54.32	54.34	1855828.0
2010-12-31 11:30:00	QQQ	ETF	54.35	54.36	54.32	54.3302	1231551.0
2010-12-31 12:00:00	QQQ	ETF	54.33	54.37	54.33	54.36	1386533.0
2010-12-31 12:30:00	QQQ	ETF	54.36	54.37	54.27	54.315	1235643.0
2010-12-31 13:00:00	QQQ	ETF	54.32	54.36	54.3	54.3507	523944.0
2010-12-31 13:30:00	QQQ	ETF	54.36	54.41	54.33	54.36	1810069.0
2010-12-31 14:00:00	QQQ	ETF	54.36	54.37	54.35	54.365	826634.0
2010-12-31 14:30:00	QQQ	ETF	54.37	54.41	54.36	54.39	950038.0

> showing 50 of 8,714 rows — these rows as CSV

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